5 Replies Latest reply: Feb 23, 2017 7:29 AM by Rahul Pawar RSS

    Sum If Condition

    KYPARISIA PAPANIKOLAOY

      Hello all!!!

       

      I need help,  i have the above expression but it doesn't work...

       

      if(YEAR='2016' and Store='FO Type 5', sum(TOTAL PARTPATT='5 ΕΜΠΟΡΕΥΜΑΤΑ FO'[Net Sales]))

       

      All the green fields are dimensions.

       

      I want to make that calculation..

      if year =2016 and store=FO Type 5 then calculate the Total sum of Net Sales but for a different dimension wich is PARTPATT=5 ΕΜΠΟΡΕΥΜΑΤΑ FO

       

      Thank you very much in advance!

      Kyparisia