5 Replies Latest reply: Mar 21, 2018 9:40 AM by William Christensen RSS

    Where not Match

    Erica Trotter

      Hi I'm trying to create a calculated dimension where the values are 'Both', 'GLS/HT', 'Encore', or 'Neither' but the 'Neither' isn't working. this is what I have so far:


      =

      IF(

       

          Match([Workday.W_CODE],[GLS.W_CODE]) AND Match([Workday.W_CODE],[Encore.W_CODE])

          , 'Both'

          , IF(

          Match([Workday.W_CODE],[GLS.W_CODE])

              , 'GLS/HT'

              , IF(

              Match([Workday.W_CODE],[Encore.W_CODE])

                  , 'Encore'

                  , IF(

                  Match([Workday.W_CODE],[Encore.W_CODE],[GLS.W_CODE])=0

                  ,'Neither')

                      )

               )

      )

            

      Please let me know if you have any ideas to fix it!

      Thanks