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

      sum(Total<A,B,C>Revenue)

       

      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.