Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=
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')
)
)
)
Hi,
can you attach some sample data ?
I saw it on another thread Where not match?
Sorry I deleted the first message because I was maybe wrong..
would you be able to attach some data ?
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
=
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')
)
)
)