#type error, and parameter not recognised

[Scotbot]

Hi,

I have a report as shown in 1.jpg.

First issue:

I'm trying to add a field on the 'Activity Code Header' line which calculates the SUM of the field 'Taxable' which is on the 'PMI Code Header' line. I've used the formula =SUM([Taxable]) and this doesn't show an error in design view but asks me for the value of [Taxable] when I run the report. [Taxable] is a calculated field that I have created in the report, it isn't in the underlying query.

Second Issue (more of a curiosity really, not essential that this works as it was just a test):

As a test I tried the formula =SUM([Bonus]) on the 'Activity Code Header' level and it showed the correct value, but the [Taxable] calculated field then showed a #type error instead of the result of its calculation.

I'd appreciate it if anyone could shed some light on this.

Cheers, Scott.

(Edited for spelling and grammar)

 

[Beetle]

You can't reference a calculated control in the Sum function, you need to redo the calculation. So it should look like;

=Sum([Bonus]*[whatever the rest of your calculation was])