Skip to Content
0
Feb 09, 2011 at 05:27 PM

Calculated Key Figure That References Characteristic Value

39 Views

I am trying to create a new calculated key figure that references the value of the a characteristic in that row in order to determine which calculation to use. Below is how I would like the calculated key figure designed:

Estimated Net Sales = IF ( TransactionType = "ABC" ) THEN ( Price - Cost - Discount ) ELSE ( Price - Cost + Discount )

The key thing here is that I need the Estimated Net Sales to be calculated differently for a TransactionType of ABC than it would be for TransactionType of XYZ.

Is there any way that we can accomplish this through query designer?