Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I have a calcultade dimension like this to only see quotas above 1,15. However I want 1,15 to be a variable instead and I want this variable to be controlled by a variable slider. I have tried to insert the figure "Variable input" to do this but withou succeeding. Below you see the expression where I want to change 1,15 to a variable.
How do I write my variable to fulfill this?
=if([Salary measure]='TTC',
If(AGGR(avg([TTC_1])/avg([MarketData.TTC]),IPE,Country,Currency)<1.15,NULL(),IPE),
If(AGGR(avg([1])/avg([MarketData.ABS]),IPE,Country,Currency)<1.15,NULL(),IPE) )
What did you used to select or entering the input? Is that the extension or from bundles?
=if([Salary measure]='TTC',
If(AGGR(avg([TTC_1])/avg([MarketData.TTC]),IPE,Country,Currency)<$(vInput_Value),NULL(),
If(AGGR(avg([1])/avg([MarketData.ABS]),IPE,Country,Currency)<$(vInput_Value),NULL(),IPE) ))
Create a new variable on front end vInput and call this variable in Variable Input objects and do the setting as per your requirement
Now you can modify your expression as below
=if([Salary measure]='TTC',
If(AGGR(avg([TTC_1])/avg([MarketData.TTC]),IPE,Country,Currency)<$(vInput),NULL(),IPE),
If(AGGR(avg([1])/avg([MarketData.ABS]),IPE,Country,Currency)<$(vInput),NULL(),IPE) )