I suggest you ...

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.

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Daan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base