Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

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 301
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