I want to make a slider based on a calculated value, it's like:
also another one:
if(sum(dataC)=0 or sum(dataC)<1,0,Num( (sum(dataC)-sum(dataD))/sum(dataC) , '#,##0%'))
Is it possible to do that?
Not as far as I know. Selections can be made in fields, not expressions. You can tie the slider to a variable and use the variable in an expression to check if the value in another expression matches the value of the variable.
THANKS! Could you tell me how to set variables?
Retrieving data ...