2 Replies Latest reply: Aug 1, 2012 11:46 PM by Oleg Troyansky RSS

    Comparing sums

      So I'm comparing the sum of field1 with the sum of field2. I want to display the "agencyID" when the sum of field 1 and field 2 are not equal to each other.

       

      However, there are many agency ID's associated with each of those sums but I want to display the agency ID that made the sum of field 1 and field 2 not equal to each other.

       

      I want to put this in a straight table