1 2 Previous Next 15 Replies Latest reply on Jun 8, 2018 9:29 AM by Deepak Rai

    If Statement With Empty Values

    David Matthews

      Thanks in advance. I'm having a little trouble if an if statement which is using empty values. I'm sure its easy for someone else to see. Basically I want the following logic

       

      If Column2 = 'M' THEN 'ValueM

      IF Column2 = 'R' THEN 'ValueR'

      IF Column2 = 'R' AND Column1 = 'M' THEN 'ValueP'

       

      I've tried using an if statements with ISNULL or ='' but it shows different things. Any suggestions on the proper syntax for this? It looks like its treating column2 as empty instead of null to me. The below screenshot shows the values for column2 if I drag it onto the dashboard by itself.

       

      A snippit of sample data taken from the db and put in spreadsheet is:

       

       

       

       

      Column2Column1
      S
      S
      RM
      R
      R
      R
      R
      M
      R
      RM
      R
      R
      RM
      M
      RM
      R
      RM
      R
      RM
      S
      M
      RM
      R
      R
      R
      R
      RM
      R
      S
      R
      RM
      RP
      M
      R
        1 2 Previous Next