6 Replies Latest reply: Aug 5, 2018 5:08 PM by Marco Wedel RSS

    Need to nested if condition replace with pick match function

    Sushant Bhaskar

      I am working on table. I have table Like -

       

      ApplicableReportedResult
      YYYes
      YNNot Applicable
      NNNA

       

      I have done this issues using the "Nested If" condition.

      like -

       

      If(Applicable='Y' and Reported='Y', 'Yes'

          ,if(Applicable='Y' and Reported='N', 'Not Applicable'

          ,If(Applicable='N' and Applicable='N', 'NA'))) as "Result"

       

      but I want to do this using the "Pick and Match function" because there is two condition (Applicable and Reported). how it possible.

      Please help.