Calculation context: Subtotal not correct

building reports webintelligence
1

Hello all,
I’m trying to get a correct subtotal in my report but instead of i’ve got the as result the value of Grand Total. Could you please please to solve this problem.
My Formula:
=Sum ([Revenue 1] ForEach ([Mitglied];[Case Nr])) In ([Risikobezeichnung])

Please look at the attached file

Thanks
Webi_Subtotal.xls (22.0 KB)

lamso (BOB member since 2008-04-03)

2

I don’t think you need to be that complicated. From the looks of the excel sheet you’ve attached, your table is broken on [Risk]?

If so, does it not work for you if you put the same formula in the body of Revenue one in the subtotal line? So is all you need not just:

=[Revenue]

I don’t think you need the sum and the contextual elements of your formula (if you’ve got the break in i think you have) & you’re overcomplicating it.

S

SteveD :uk: (BOB member since 2009-11-02)