Choose Function

Contains one or more When expressions that are equivalent to if...then, if...then, followed by an optional Otherwise expression that is equivalent to an Else clause.

Example

choose(when(TotalValue>='10000', 'High'),when(TotalValue>='5000','Medium'),otherwise('Low))