4 Replies Latest reply: Jun 24, 2011 10:42 AM by Waqas Saeed RSS

    Multiple aggregation in an expression

    Waqas Saeed

      Hello Experts,

       

      Just a basic stupid question.

       

      I want to subtract one column from another in a pivot table and I'm confused how should I write the expression. I know only 2 ways we can write it which are below.

       

      1-  Sum(ColumnA - ColumnB)

      2- Sum(ColumnA)-Sum(ColumnB)

       

      I got 4 columns in total. Year, Month, ColumnA and ColumnB and the problem is that I'm getting slightly different total when I use above expressions. I thought both expressions mentioned above should give me exact same result but its not. Can anyone please help me explaining the basic difference b/w abover expressions?

       

      Many thanks.