How to map a range of values to a T-shirt-size-like range (eg S/M/L)?
I would like to:
- set value2 to S If value1 is between 0 and 20
- set value2 to M If value1 is between 20 and 40
- set value2 to L If value1 is between 40 and 60
This would allow me to roll up the calculated field value1 into the value2 categories, useful when eg reporting.