8 Replies Latest reply on Aug 23, 2012 8:21 AM by Gordon Young

    Categorizing Difference Between 2 Columns

    Gordon Young

      I am calculating difference between 2 different columns using a calculated field. I have then categorized the difference as Positive, Negative or Equal using a calculated field based upon the difference calculated field.

       

      Difference Table.png

      I'm having is that I want to group the above by the Difference Category and sum the Difference column. The problem is that that when I try to group by the category, the difference is calculated and then the category is determined.  As a result, I only always only get one category back with the net sum of the difference column.

       

      I've attached the sample file.  I would greatly apprieciate if anyone has ideas on how to do this.

       

      Thanks.