2 Replies Latest reply on Aug 7, 2018 7:26 PM by meenu choudhary

    IF or is it IIF or is it CASE

    Rachel Dickey

      Good Evening!

      trying to do an if statement (like I can do in access).

      I have a column name TYPE and inside there is 6 types that I would like to name. They are numeric.

      I tried aliases but it won't let me name the same name.

      I tried writing an if statement like I would in access but keep getting a Boolean formula error.

       

      if(type=2, 'Soft',

      if(type=3, 'Super Soft',

      if(type=4, 'Extra Soft', 'Regular')))

       

      What am I doing wrong!

        

      Can't show data with my company.

      thanks,

      Rachel