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.

1 Reply

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

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

    )