<div>
Does this help?<br />
<a href="http://blogs.msdn.com/b/robertbruckner/archive/2008/07/20/using-group-variables-in-reporting-services-2008-for-custom-aggregation.aspx" rel="ugc">http://blogs.msdn.com/b/robertbruckner/archive/2008/07/20/using-group-variables-in-reporting-services-2008-for-custom-aggregation.aspx</a>
</div>


Does this help?
http://blogs.msdn.com/b/robertbruckner/archive/2008/07/20/using-group-variables-in-reporting-services-2008-for-custom-aggregation.aspx [http://blogs.msdn.com/b/robertbruckner/archive/2008/07/20/using-group-variables-in-reporting-services-2008-for-custom-aggregation.aspx]

<div>
<div class="content wysiwyg-content">
I have a report that currently lists data like:<br />
<br />
DEPT &nbsp; &nbsp; &nbsp; &nbsp; % &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;--Row<br />
-------------------------<br />
Supply &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18.00 % &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;--Group<br />
Marketing &nbsp; &nbsp;12.01%<br />
Sales &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5.03%<br />
...<br />
--------------------------<wbr /><br />
<br />
I need to be able to provide a rollup of the percentages. So in this example it would report back 11.68%<br />
<br />
The issue is that the '%' column expression is<br />
=round(sum(iif(Fields!MTR.<wbr />Value = &quot;False&quot;, 1, 0))/Count(Fields!MTR.Value<wbr />),2)<br />
<br />
So what I am 'trying' to do is something like<br />
=AVG(round(sum(iif(Fields!<wbr />MTR.Value = &quot;False&quot;, 1, 0))/Count(Fields!MTR.Value<wbr />),2))<br />
<br />
but I get an error about <br />
'The value expression for the textbox 'textbox71' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggreagte functions.<br />
<br />
Ideas for a work-around?
</div>
</div>


I have a report that currently lists data like:

DEPT         %                         <--Row
-------------------------
Supply          18.00 %             <--Group
Marketing    12.01%
Sales              5.03%
...
--------------------------

I need to be able to provide a rollup of the percentages. So in this example it would report back 11.68%

The issue is that the '%' column expression is
=round(sum(iif(Fields!MTR.Value = "False", 1, 0))/Count(Fields!MTR.Value),2)

So what I am 'trying' to do is something like
=AVG(round(sum(iif(Fields!MTR.Value = "False", 1, 0))/Count(Fields!MTR.Value),2))

but I get an error about 
'The value expression for the textbox 'textbox71' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggreagte functions.

Ideas for a work-around?

SSRS 2005 Roll Up Average in Report

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.