Trouble retrieving a distinct sum amount

[austin22]

I am using Crystal 8.5

Here is my setup:

RecordNumber TransDate TransAmount

1234 10.07.07 25.00
5678 10.14.07 5.00

Total transaction amount is $30.00, however, the problem I run into is duplicate line item when in reality there is one line item. Example:

2468 10.07.07 25.00
2468 10.07.07 25.00

Total transaction amount comes out to be 50.00, when it should be just 25.00. How do I get a distinct sum amount if there is a duplicate record.

 

[lbass]

You could first try going to database->select distinct. Otherwise, you can insert a running total that does a sum an evaluates on change of field {table.recordnumber}, assuming you are sorting by this field.

-LB

 

[austin22]

The change of field evaluation worked! Thanks, LB

austin22