2 Replies Latest reply on Jan 20, 2014 5:59 PM by Ben Sullins

    Calculate and group results based on selected combination

    Ch Baker

      1. Create a report using same data source to generate two sets of selection filters. Selection A and B, which will be a combination of Account and Effective date.

       

      2. Calculate difference in 'value' between the selection i.e. A - B

       

      3. Group the results by using contractID to see if same ID is in specified selection . i.e. In A not in B;  In B not in A etc (p.s. we can have same selection in A as well as B)

       

      The following should give you an idea as to what I'm after:

       

      Untitled.png