Variable not working in expression

dandaanilreddy — Tue, 24 Sep 2019 18:49:39 GMT

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

Re: Variable not working in expression

Arthur_Fong — Wed, 25 Sep 2019 04:12:26 GMT

'{}' 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 .

topic Re: Variable not working in expression in App Development

Variable not working in expression

Re: Variable not working in expression