Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this,
sum(if( | wildmatch([Product],'Peer', 'Aplle') and [AR Event Date]<=EOM_Date,[AR Amt USD])) |
Regards,
Kaushik Solanki
Try this,
sum(if( | wildmatch([Product],'Peer', 'Aplle') and [AR Event Date]<=EOM_Date,[AR Amt USD])) |
Regards,
Kaushik Solanki
Try this:
Sum({<[Product]={'Peer', 'Apple'}>} If([AR Event Date] <= EOM_Date, [AR Amt USD]))
It worked thanks a lot!!
Thanks a lot