SSRS Adding DYNAMIC SCOPE to Expression Formula in Report?

Here is an example of my current formula that I'm having an issue in ADDING SCOPE. Is it possible to use DYNAMIC SCOPE in a formula like this?

The issue is when I run my report for ALL GROUPS, this formula displays incorrect percentages, but when I select a single customer within the group, the percentages are correct....

=Sum(CDEC(Fields!Status_Complete.Value), "Status")/Count(Fields!Status_Complete.Value, "Status")

Can someone help with advising how to add a GROUP scope to this above formula?
LVL 17
MIKESoftware Solutions ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
I believe this "Deciding Whether to Use an Expression or a Variable in SSRS" should help to understand the difference between cell/box and group:
http://www.sqlchick.com/entries/2010/11/24/deciding-whether-to-use-an-expression-or-a-variable-in-ssrs.html

And definitely please read "Understanding Group Membership for Tablix Cells":
https://msdn.microsoft.com/en-us/library/dd255263(v=sql.105).aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.