Create variable slider for my quota

[Bobi]

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) )

[Anil_Babu_Samineni]

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) ))

[Kushal_Chawda]

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) )