Multiple Dimensions in if sum condition

[ugurarslan]

Dear,

If have a dimension called product, which includes the following companies:

1. Peer

2. Apple

3. Banana

I need to calculate the if condition based on multiple condition in an if statement.

if I write the following I get a result:

sum(if(

[Product]='Peer' and [AR Event Date]<=EOM_Date,[AR Amt USD]))

but If I want to use the same expression on multiple products I get zero result:

sum(if(

[Product]='Peer', 'Aplle' and [AR Event Date]<=EOM_Date,[AR Amt USD]))

Can you please help me?

Thanks

Ugur

[kaushiknsolanki · Accepted solution]

Try this,

sum(if(

wildmatch([Product],'Peer', 'Aplle') and [AR Event Date]<=EOM_Date,[AR Amt USD]))

Regards,

Kaushik Solanki

[jonathandienst]

Try this:

Sum({<[Product]={'Peer', 'Apple'}>} If([AR Event Date] <= EOM_Date, [AR Amt USD]))

[ugurarslan]

It worked thanks a lot!!

[ugurarslan]

Thanks a lot