I need to create some formulas that calculate figures in both the main report and sub report.

 

For example:

 

Main report field AMOUNT + Sub Report field AMOUNT.

 

Can anyone tell me how to create formulas based on fields/formulas held in sub-reports

I've almost got it working, however the figures are not correct:

Column 1 - main report - 77462.19
Colum 2 - from sub report shared variable - 0.00

Column 1 - main report - 358038.39
Colum 2 - from sub report shared variable - 77462.16

Column 1 - main report - 236918.00
Colum 2 - from sub report shared variable - 358038.37

Column 1 - main report - 359993.77
Colum 2 - from sub report shared variable - 236918.00

For some reason the first line in column 2 is showing 0.00 - and this is throwing all of the other lines out as you can see.

Any ideas why this might be?