Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone help me to write below expression using Set Expression :
=If(Status='Imported','Not Available', If(Sum(Price)<>0,Sum(Price), If(Sum(Cprice)<>0,Sum(Cprice),If(Sum(Dprice)<>0,Sum(Dprice),sum([Dummy Price])))))
Thanks
Your expression is conditional. I do not think you can replace what you are doing leveraging Set Analysis. You could do that if you were defining your selection criteria using IF statements, but you are changing the expression itself.
Also, note that Set Analysis happens before the dimensionality so if won't change the data by the dimension value's result (Ex: Sum(Price)<>0).
Your best case scenario is to modify your data model to accomodate this logic.