Where not Match

[etrotter]

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

[YoussefBelloum]

Hi,

can you attach some sample data ?

[etrotter]

I saw it on another thread Where not match?

[YoussefBelloum]

Sorry I deleted the first message because I was maybe wrong..

would you be able to attach some data ?

[gerry_hdm]

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],'Neither')

                )

         )

)

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

and  the next ceil  idnetity

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

you see no datas

[wdchristensen · Accepted solution]

=

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

           'ZeroValue','Neither')

                )

         )

)