Grand-total from sub-total in a report which has been grouped?

[rasghar12]

Hi,

I have a report which has been grouped, i've managed to produce a formula which calculates the sub-total for each group.

Now i need some way of producing a grand-total from the sub-totals, is there anyway of doing this?


Thanks in advance

 

[pbaldy]

Typically you'd have

=Sum(FieldName)

In both the group footer and the report footer. It would produce the appropriate total in each.

 

[rasghar12]

I tried that before, but it didnt work.
However, by playing around with different formulas and methods I managed to create something that worked.
Thank you for your help anyway

 

[pbaldy]

Happy to help. Posting the solution that worked for you could help someone searching for a solution in the future.

 

[rasghar12]

I don't think so as the total in my report is based on a few different fields which have different calculations, but i'll give an outline of what i did.

To do the grand-total I:

1) Create a sum of total
2) Created another sum of a different total

Then for the grand total, i used the Nz function to add up the two sums and take pre-caution if there was a null value.

Hope this helps someone in the future.