Double counting problem in cr2008

[sap1958]

Here is some sample data
giftkey amount date giftid
00001 25 3/13/2010 21
00001 25 3/13/2010 21
00002 25 3/13/2010 21

In this scenario it appears that $75 was paid. However the first two entries duplicate and should actually be one transaction. The amt given is actually $50. I constructed a running total based on the group giftkey. The running total is as follows

field to summarize = amount
evaluate = on change of group giftkey
reset on change of group giftid (or when the giftid changes)
the problem is the running total only counts the amount or in this case $25

the data rests on the detail line. this allows me to analyze the duplicates. What can be done to sum the totals and avoid the duplicates.

 

[NiceArms]

Hi Sap1958,

It would be best to confirm why you are getting duplicates and remove them....I realise this is an obvious statement, but if the duplicates are not there you don't have to handle them.

I find that the joining of the tables is the main cause of duplicate data, try looking there first.

There are ways of suppressing the data so that it is not shown but only do this if you are confident that you can identify each dupicate without picking up valid data. If you want a steer on how to do this please let me know.

/Nice

 

[IanWaterman]

Remove your RT reset

reset on change of group giftid (or when the giftid changes)


Chnage to never or a higher group level.

Ian

 

[lbass]

I'm assuming you are using sum as the summary. The correct result for the GiftID will show in the Gift Group footer. If you need to summarize across GiftIDs, you need to create a separate running total, with a reset at a higher group level or with no reset (at the grand total level). In all cases the results must be displayed in the appropriate footer section.

-LB