SUM function in report field

[tikkat3]

I am having real trouble with a very basic adding scenario. In my report footer I have a field [Total Men 1st Fix] to total up the results of the columns in the detail section and a second field [Total Cost 1st Fix] that calculates a currency value based on the results of [Total Men 1st Fix].

Example: in detail section I have 2 columns of fields [1st Fix Planned] & [1st Fix Actual]. The [Total Men 1st Fix] field in the report footer has the Control Source calculation expression "=SUM([1st Fix Actual]-[1st Fix Planned])". This gives the correct figure.
The [Total Cost 1st Fix] field below that gives a currency value using the following expression "=[Total Men 1st Fix]*19.49". Again this gives the correct results.

I have about 4 columns using the above example. My problem comes when I want to total the 4 columns in the [Grand Total Men] field (should calculate the sum of the "Total Men ... Fix" fields), and in the [Grand Total Cost] field (should calculate the sum of the "Total Cost ... Fix" fields).

These final Grand Total fields will not give a result! What am I doing wrong?!
My current expressions: "=SUM([Total Men 1st Fix]+[Total Men 2nd Fix])" etc
and "=SUM([Total Cost 1st Fix]+[Total Cost 2nd Fix)" etc.

Any help is appreciated.

 

[Rich]

You have to repeat any calculation within the summation, ie Sum([field1]*[field2])