I would like to calculate a field according to a value of another field in the Datamart but am unable to do so. What is the correct expression?
I tried:
IF(ColumnNumber=1,GrossSales,"") CASE ColumnNumber WHEN 1 THEN GrossSales END
I would like to calculate a field according to a value of another field in the Datamart but am unable to do so. What is the correct expression?
I tried:
IF(ColumnNumber=1,GrossSales,"") CASE ColumnNumber WHEN 1 THEN GrossSales END