Summary on a non-recurring field error

[travelerII]

I am using Crystal 10 and I am creating a report to show sales in various catergories and then a total freight. Freight is recorded in the elements of the sales invoice and when I put in a formula for the freight it returns the total freight amount for each line of the invoice so if there a 4 lines on the invoice I get 4 times the freight. I tried to solve this with the following formula
IF(({SINVOICEV.DTAAMT_0}*{SINVOICE.SNS_0})+ ({SINVOICEV.DTAAMT_1}*{SINVOICE.SNS_0}))= 0
THEN 0
ELSE(({SINVOICEV.DTAAMT_0}*{SINVOICE.SNS_0})+ ({SINVOICEV.DTAAMT_1}*{SINVOICE.SNS_0}))/(Maximum ({SINVOICED.SIDLIN_0}))/1000

where I am taking the freight and trying to divide it by the maximum line number on the invoice ie freight of $251.76 divided by (max line number 4000 divided by 1000) or $251.76 divided by 4. When I do this I get the following message
"A summary has been specified on a non-recurring field. DetailsFreight"
and the report won't run.
Any help for a solution to this problem is greatly appreciated.

 

[IanWaterman]

If the above formula is @Freight then you can not summarise it as it already contains a summary.

YOu will have to find another way of allocating freight costs for the report or group total.

Ian

 

[GJParker]

The most common approach to this is to insert running totals at each of the required group and footer levels.

Sum the freight once at the sales invoice group level and set reset to the appropriate group level for each running total.

HTH

Gary Parker
MIS Data Analyst
Manchester, England