Cannot sum a formular from the detail section 1

[awinter]

Hi, I am having a problem getting a formular to sum in crystal 8. I have created the following formular,

shared numberVar price;

if shared numberVar price<{RELACK.SELBSTKOSTEN}
then (({RELDLB.LAGERMENGE}*shared numberVar price)/{RELACK.BASIS})
else (if {RELACK.SELBSTKOSTEN}=0
then (({RELDLB.LAGERMENGE}*shared numberVar price)/{RELACK.BASIS})
else (({RELDLB.LAGERMENGE}*{RELACK.SELBSTKOSTEN})/{RELACK.BASIS}))

This is to compare part prices and value some stock.
The shared variable come from the part sales price data table and can have multiple values.
The data is grouped using the part number.
The problem I am having is that I cannot use the subtotal, Grand total function. Is there another way to put a subtotal in each section and also a grand total at the end of the report.

regards
Allan

 

[Naith]

You can assign the value of this formula to a cumulative variable, and call this variable in the footer of your report.

i.e.

whileprintingrecords;
numbervar grandtotal := grandtotal + {@yourformula}

in your detail section.

Follow the same process for your subtotal, but remember to reset the subtotal variable in the group header.

Naith

 

[awinter]

Spot on worked a treat, easy when you know how.

Thankyou