How to get grand total %'s when using a BREAK control?

[williampeck1958]

Is there a trick to get grand total %'s when using a break? The data shows total % WITHIN the break, but I want it to be a grand total %.

I can get the numbers I’m looking for by NOT having a BREAK control, but it’s not too visually appealing. Plus you can’t get BREAK totals

[MarkP]

There should be something simple like
=sum([Value])/sum([Value]) in (Report)

Calculation contexts for breaks function slightly different to an unbroken report (as you’ve seen) but there are extras like In Report and In Break that can help you.

[williampeck1958]

MarkP - - - sounds good but it’s not working for me …

I was able to get the total total within the break section like this (4,444):
=Sum(Count([In School (4 years)].[Student_Id])) ForAll ([vMinority])

But then I tried your suggestion by saying
=Sum(Count([In School (4 years)].[Student_Id])) / sum(Count([In School (4 years)].[Student_Id])) in (Report)
but it says “Missing object identifier in ‘Report’ at position 85”

I also just tried dividing the row value by the 4,444 formula, but it all came out 100%
=Sum(Count([In School (4 years)].[Student_Id])) ForAll / Sum(Count([In School (4 years)].[Student_Id])) ForAll

but Thank you!

[williampeck1958]

I found an answer on SAP Community forum, but I would still like to understand your suggestion (and my syntax error).

What worked for me was to create a variable for the count and a variable for the % of the grand total …
=Percentage([vBreak Total (Minority)]) In ([vMinority])