How to display value based on a range?

  • Profile Image
    tonyberber
    Asked on November 09, 2016 at 02:33 PM

    I have a field that sums up values from lots of previous fields. This sum ranges from 0 to 400. I'd like to have a further field that displays a particular message based on the value of that sum. For instance:

    -if sum = 400, then display 'L4' 

    -if sum < 400 and >=320, then display L3 

    -if sum < 320 and >=240, then display L2

    -if sum < 240 and >=160, then display L1

    -else display = LNC

    Is that possible?

    Thank you!

    Tony

  • Profile Image
    Nik_C
    Answered on November 09, 2016 at 05:39 PM

    Hello Tony, thank you for contacting our Support.

    You should be able to achieve that with conditions and number field. What I mean is, you will have to store the sum into a number field:

    And then by using conditions state 'less than' and 'greater than' you can create a range that you need and show appropriate fields.

    For <= and >= just create an additional condition that will have 'equal to' state as well.

    Let us know if this could work for you.

    Thank you!

     

  • Profile Image
    tonyberber
    Answered on November 11, 2016 at 07:07 AM

    thank you, I'll try that!