Summed Amount Overstated 1

[TimothyP]

I have a table that looks like this:

Invoice# Amount
1234567 $25.00
1234567 $25.00
1234567 $25.00
7778657 $77.00
9998976 $44.00

I have a Crystal 8.5 report grouping by invoice so the invoice and amount only show once.

I also have a sum field adding all the invoice amounts.

The problem is the summed amount includes all three $25 amounts for invoive 1234567

What kind and where can I use a formula to only use one amount per Invoice?

It's not an ODBC so I do not have the select distinct records option.

Thanks for your help,
Tim

 

[rosemaryl]

Dear TimothyP,

You can use a running total.

Go to the field explorer, click on the Running Total Fields heading, Click New and populate the dialog box that appears appropriately:

Name: Give it a name otherwise it stays RTotal0 which isn't informative ...

Field To Summarrize: Select the Invoice Amt Field
Type of Summary: Sum

Evaluate On Change of Group: the Invoice # Group

Reset: Never

you will now have summed your invoice totals for all invoices on your report ...


Regards,
ro


Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762