3 Replies Latest reply: Mar 9, 2017 12:57 PM by Sunny Talwar RSS

    Using if to multiple values in a field

    Eduardo DImperio

      Hi everyone,

       

      I have a Field name ALERT with values from 1 to 10, and i want this output

       

      Case:

      Alert <=2, 'None'

      Alert >2 and Alert<=6, 'Normal'

      Alert >6 and Alert<=10, 'Urgent'


      How can i right this?

      i had thought to use several ifs, but doesnt work in the same field or i dont know how to write.


      Thank you