SSRS Aggergate Data

Need to add a column to the attached report to calculate the metric of % Correct:
But when I attempt to add the formula:


/CUST_ACCT_METRIC_NUM is invalid.  The Value expression for the text box 'Textbox10' has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.

I believe from my screen shot you can see that [BUCKET] is a valid grouping.

Ultimately, I would only want the total if the value in the "BUCKET" is = 'CORRECT' only.  I need to calculate the % "CORRECT' over the over-all total.  

Who is Participating?
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:
It looks like [Bucket] is only a label and  you should look at using the scope option to the aggregate operators like:

...=SUM(Fields!ID.Value, "NameOfRowGrouping") / SUM(Fields!ID.Value, "TopLevelGroupName")

and also to move it out of the expression and to either the placeholder properties or text-box property that contains the value.
Travis456789Author Commented:
How do you identify the name of the "NameOfRowGrouping" and the "TopLevelGroupName"?  

Is it in the Group Column names or can I see it in the properties somewhere?  I have tried just about every combination that I can find.
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Hi Travis456789,

Please try the following solution.

You can simply add the column after the Column group. And put an expression to calculate the percentage of Correct. I have use the temp table to generate the dump data. It's having the Customer Order amount monthly.

Row group on Customer and Column group on Month.

Calculated the Even Month % and Odd Month %.
E.g. Even Month %  expression is
=ROUND(SUM(IIF(FIELDS!Month_Name.Value MOD 2=0,CINT(FIELDS!SubTotal.Value),0))/SUM(FIELDS!SubTotal.Value),2)*100

I have attached the Query and the RDL file.

Hope it will help you.

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

From novice to tech pro — start learning today.