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