Avatar of Travis456789

asked on 

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.  

SSRSMicrosoft SQL Server 2008Microsoft SQL Server 2005Microsoft SQL ServerDatabases

Avatar of undefined
Last Comment
Arifhusen Ansari

8/22/2022 - Mon