The format of my report is:
GH1, GH2, GH3, D, GF3, GF2, GF1
I have a formula fields calculating manual running totals for groups 1 and 1. Groups2 and 3 are hidden from report but allow drilldown. When I run report, GF1 running totals are fine. If I then doubleclick on GF1, the GF2 details including its manual running total is displayed. However both the GF2 and GF1 manual running totals are now displaying the wrong values.
If I amend the report to display all GF (i.e. no hidden sections) all the manual running totals are displayed correctly.
I've been banging my head off a brick wall on this for hours now, so would appreciate any assistance/suggestions anyone can provide.