Multiple match condition

[#1]

I have the following dimension set up to only show Res Id with the following values but I also need to extract the data if the

GP ID is equal to CTL01

Is there a way for me to do a match if either one exists????

=if(Match([Res ID],'100529','400068','104198','609022'),'ABC Supply')

[erikzions · Accepted solution]

=if(Match([Res ID],'100529','400068','104198','609022') or [GP ID] = 'CTL01','ABC Supply')

This might do what you need.

[maxgro]

you can add and or condition to your if as needed

if( (match(....) or match(.....)) and (match(.....) or match(.....)), ...) as ....

[#4]

if I need to add another layer such as

an and ID = 39 or id not equal 39

in other words (if the res id = '100529', etc, or gp id = CTL01 ) and id = 39

would this be possible?????

[its_anandrjs]

You can simply use

=if(Match ( [Res ID], 100529,400068,104198,609022),'ABC Supply') or Match( [GP ID] = 'CTL01','ABC Supply')

   And ID = 39