Skip to Content
0
Former Member
Feb 17, 2009 at 09:40 PM

Summing issues

15 Views

I show detail lines similar to that shown below:

  1. Cost Value

123 40.00 11,600

333 35.00 5,500

123 40.00 11,600

I show the total of the three entries for cost (40 + 35 + 40) but for the value column I only want to total (11,600 and 5500). I want to exclude 11,600 for the second record that has the same # as prior records (in this case 123). How would I be able to accomplish this? Thanks in advance