16 Replies Latest reply: Jul 13, 2018 5:03 AM by Jade Pepler RSS

    How to set condition based on unique values using 2 lookup columns?

    Jade Pepler

      Good Day,

       

      I please need assistance,

      I wish to return either the Value 'R', or 'NR'

       

      The File column has many unique values, and is accompanied by ALL with only 2 possible values.

       

      To paint the picture, I want the dimension to tell me if the whole file is 'R' for ready, or 'NR' for not ready.

       

      If all fields are populated with 'R', then the file is ready, but if just 1 'NR' is displayed on that specific file, then it must populate all fields to 'NR'.

       

      ***Remember, this must be done on a file level, so the fx must perform it's task per file and not on the entire column.***

       

      Screenshot:

       

      File R or NR.png