I'm using this expression in the GROUP Header area of my report:
=Sum(CDEC(Fields!Status_Complete.Value), "Status")/Count(Fields!Status_Complete.Value, "Status")
The percentage results seem to be calculating based on the ENTIRE REPORT and not each specific GROUP.
How can I add some kind of SCOPE parameter into this formula to advise the report to calculate the percentage based on each GROUP as opposed to the entire REPORT?
(Note: when I run the report for ALL groups, then the percentage calc is the exact same for all GROUPS and I believe it is based on the entire SUM of all Groups. When I run for a specific GROUP, the percentage calc is correct for that single GROUP)