Issue when using IFS expression

I have an issue when trying to use the IFS expression to perform calculations using the Order Capture Sample app. The expression to calculate totals on the Order Details table is as follows: [Product Id].[Price] * [Quantity]. This expression is used for all products. However, I am trying to customize the app so that each product has a unique calculation. When I enter the following expression: IFS([Product Id]=โ€œStrawberryโ€,[Product Id].[Price][Quantity].02,[Product Id]=โ€œKiwiโ€,[Product Id].[Price] * [Quantity] * .05,[Product Id]=โ€œRaspberryโ€,[Product Id].[Price] * [Quantity] * .2) the Total disappears from the UX and no total is calculated. Any Suggestions?

Solved Solved
0 9 283
1 ACCEPTED SOLUTION

I actually just figured it out. I was using an incorrect reference.

View solution in original post

9 REPLIES 9
Top Labels in this Space