Hi, I have report request where they want the VP team members to include their Manager level detalis in cols (1-8) & to only display that Manager level when someone has a manager at that level. In details, I filter by the predefined absence rules, one of which is based on the avg absence for the VPs team. I reflect the VPs team avg & target (avg*1.5) in the group header. For the col visibility in each Manager level col, I applied the following filter which generates the aggregate error: =IIF(sum(IIF( ((Fields!Non_Occ_Hrs.Value/7.5 > Parameters!Parm_LostDays_Min.Value AND Fields!Non_Occ_Hrs.Value/7.5 > AVG(Fields!Non_Occ_Hrs.Value)*Parameters!Parm_LostDays_Factor.Value) OR (Fields!Non_Occ_Hrs.Value/7.5 > Parameters!Parm_LostDays_Max.Value)) AND (Fields!Mgr_Name_02.Value <> "") , 1, 0)) = 0, TRUE, FALSE) As you can see, I have an AVG within a SUM. How can I resolve around this? Thanks, JeffJeffrey Daley

ya you cant do nested aggregates in your SSRS version. You can include the average in your query but I noticed in your other thread you mentioned not wanting to modify your query with subqueries. Another possibility is using custom code: http://blogs.msdn.com/b/robertbruckner/archive/2008/07/20/using-group-variables-in-reporting-services-2008-for-custom-aggregation.aspx