How do I sum this formula field?

[huggybear]

I'm using Crystal 11 to query an Access 2k database. I have quite a bit of experience using Access and its built-in report tool but am very new at Crystal.

The objective is to get a total of billable hours of several technicians. In the report I have a formula (@Money) to calculate the billable of each tech:

dim hours as double, regular as double, rate as currency, otime as double
hours = Sum ({TransService.ServiceHours}, {TransService.ServiceTech})

regular = 40
rate=68

if hours <= regular then
    formula = hours * rate
else
    otime = hours - regular   
    formula = (regular * rate) + ((hours - regular) * (rate*1.5))
end if

That works very well.

Now if I try to create a grand total for all the techs by creating the following formula:

formula = Sum ({@Money})

the formula editor tells me "This field can't be summarized"

How do I get that grand total?

 

[lbass]

You need to use a variable. In Crystal syntax, you would use a formula like the following in the group (technician) header or footer:

whileprintingrecords;
currencyvar billhrs := billhrs + {@Money};

Then in the report footer you would use the following to display the result:

whileprintingrecords;
currencyvar billhrs;

Not sure how to translate this into Basic syntax...

-LB

 

[huggybear]

Thanks LB, that worked like a charm. Turns out I couldn't figure out the Basic syntax so I went ahead and used Crystal.