Error :A summary has been specified on a non-recurring field

[f0rg3tfu1]

Hello everyone,

CR 10
Just got an error message:

A summary has been specified on a non-recurring field.
Details: @freight_rate

Heres my formulas:

@freight_rate =
Sum ({@totals}, {adq_vw_part_cost_trans.gl_id}) * {?Freight Rate}


@totals =
{@issue} + {@rts}


@issue =
if {adq_vw_part_cost_trans.tran_type} = 3 then
{@ext cost}


@rates =
if {adq_vw_part_cost_trans.tran_type} = 4 then
{@ext cost}


@ext cost =
if {adq_vw_part_cost_trans.tran_type} = 3 then
{adq_vw_part_cost_trans.unit_cost}*{adq_vw_part_cost_trans.quantity}
else
{adq_vw_part_cost_trans.unit_cost}*{adq_vw_part_cost_trans.quantity} * -1

The final goal is to add up the calculated fields.
Any clues? Im pretty sure it has something to do with the passes, but Im brain dead.

 

[paulmarr]

Hi forgetful,

Your formula contains a summary - Sum ({@totals}, {adq_vw_part_cost_trans.gl_id}) - this total is calculated in the first pass in Crystal - which probably isn't available at the time Crystal wants to calculate it.

Cheers,

paulmarr

 

[dk87]

Create a group on {adq_vw_part_cost_trans.gl_id} if you want to summarize by it. Also, you have a formula @rates, but do not show the one referenced in @totals called @rts

 

[f0rg3tfu1]

Formula @rts =
if {adq_vw_part_cost_trans.tran_type} = 4 then
{@ext cost}

I already have a group on {adq_vw_part_cost_trans.gl_id}

Here is how the final report is coming out (Abbv. version):

Inventory Freight
Adjustments by Date
8/10/2004 to 8/31/2004
Freight Rate:0.12

GL Account - Org ID - Project ID - Issues - Return to Stock - Total - Freight Amount

DETAIL

(GLACCT) - (ORGID) - (PROJECT ID)- $51,774.96 $6,432.36 $45,342.64 5,441.12

-----------------------------------------------------------

The last boldface number is supposed to be the "Freight amount" which is the total*{?Freight Rate}... the field that I am having problems with.

Any ideas? Please let me know if I have provided enough information.

I had a feeling it had to do with the first and second pass... any ideas on how to get around it?

Bottom line, if I can take the actual values of {SUM OF @FREIGHT RATE} at the group level and add them up, I should have the correct total.

Clues? Suggestions? Kind Words?

 

[dk87]

And your formulas are all places on your details section so that they are processed?

 

[f0rg3tfu1]

No the formulas for the summary are in the Group 2 section, {adq_vw_part_cost_trans.gl_id}.

I spoke with our accounting department, and we had used a formula at another time that seemed to work, except it seemed that it was always off by change.

The old formula was:
@freight_rate = {@totals} * {?Freight Rate}

Now like I said this seemed to work, but it was pennies off every time. This is what lead me to believe it was a rounding problem rather than a formula problem... but I really couldnt narrow it down.

I should have mentioned it before but I wasnt thinking straight. Hopefully this will help.