This content has been marked as final. Show 4 replies
If have a dimension called product, which includes the following companies:
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:
[Product]='Peer', 'Aplle' and [AR Event Date]<=EOM_Date,[AR Amt USD]))
Can you please help me?