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?