2 Replies Latest reply on Sep 1, 2017 11:58 AM by Krish Ko

    case or iif or If  for multiple numbers

    Krish Ko

      Hi Gurus,

       

       

      I have scenario  of random numbers like

       

      1,2,3,5,6,7,10,14,16,17,19,21,22,24,26,27,88,123,124,126 etc.

       

      in calculate field I  want display

       

      1,2,3,5                             are   A

      6,7,10,14,16                      are B

      17,19,21,22,24                are   C

      26,27,88,123,124,126    are    D

       

      In case statement or IIF  or If we may handle multiple numbers ?

      Please help me syntax.

       

      Appreciate your response