6 Replies Latest reply: Mar 5, 2014 4:02 PM by Massimo Grossi RSS

    Using if, sum, Total in the same Expression

      I have an expression as



      I want to put an if condition in the same. When i put if condition in beginning like:


      if(Quarter='Q1', sum(Total<A,B,C>Revenue),0)


      it does not give any result.


      How should i write the expression for it to work.