Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am facing issue with a variable in my expression. Even if i hard code the value for the scenario my expression is not working. When ever i comment the scenario part the expression is working fine. . I want to compare 2 scenarios based on the selections. Scenario 1 and scenario 2. For this i have added the 2 scenario variables as dimensions and the below expression. Please can someone look into this?
num(Sum(if(right(IAC,2)='A1',
if(Scenario={'$(vScenario1)'},
if(right(business,5)='Ratio',value*100,
value))))/Unit_Value,'$(vDecimal)')
Thanks
'{}' is not required in if statement.
Try:
num(Sum(if(right(IAC,2)='A1',
if(Scenario=$(vScenario1),
if(right(business,5)='Ratio',value*100,
value))))/Unit_Value,'$(vDecimal)')
Check also if your variable has '=' at the beginning .