Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to make a slider based on a calculated value, it's like:
num(sum(dataA)/sum(dataB),'##.##%')
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?
Best Regards
Peter
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?