crystal report - sum(count) problem 1

[Johalak08]

I have report which has columns:
Shipment WorkDays Shipment/Diem
9 22 0.41
10 20 0.50
3 22 0.14
5 21 0.24

To calculate shipment/Diem column i used the formula
-- Count ({spSalesReportByBillTo;1.WaybillNumber}, {spSalesReportByBillTo;1.Date}, "monthly")/{@Work_Days} --

My question is, how can i get the total of the Shipment/Diem column? If i try to use SUM, i am getting the error "cannot create summary/running totals.."

Please help. You're reply will greatly be appreciated. Thank you.

 

[lbass]

You could use a variable. Create a formula like this:

whileprintingrecords;
numbervar sumship := sumship + {@shipment/diem};

Place this in the section containing your {@shipment/diem} formula. Then create a formula for the report footer:

whileprintingrecords;
numbervar sumship;

If you are trying to summarize the formula at a group level instead of at the report level, then you would need a reset formula in the group header:

whileprintingrecords;
numbervar sumship;
if not inrepeatedgroupheader then
sumship := 0;

-LB

 

[Johalak08]

Hi LB:

i did what you have advised and it works great.
Thanks