Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Switch function for percentage

How to use Switch function for 20 to 40 Percentage and 40 to 100 percentage in same function.
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

SWITCH( TRUE(), 
    [PercentageMeasure] > 0.4 && [PercentageMeasure] <= 1, "Something here", 
    [PercentageMeasure] > 0.2 && [PercentageMeasure] <= 0.4, "Something else"

)