4 Replies Latest reply: May 22, 2018 5:10 AM by Ugur Arslan RSS

    Multiple Dimensions in if sum condition

    Ugur Arslan



      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:



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


      Can you please help me?