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! Go to Solution.
I actually just figured it out. I was using an incorrect reference.
User | Count |
---|---|
28 | |
13 | |
3 | |
3 | |
3 |