Thursday, April 23, 2015

The Value expression for the text box specifies a scope that is not valid for a nested aggregate.

Hi Sam,

Try this,

=sum(Sum( Code.Divide(   sum(Fields!WeeklyUnits.Value),Sum(Fields!EstUnits.Value)     ))
*   Sum(   Code.Divide(  sum(Fields!EstHours.Value),Sum(Fields!EstHours.Value,"Job")     )))

I tried that and received the same error.

.....The scope must be the same name of the scope specified by the outer aggregate or the name of a group or data region that is contained in the scope specified by the outer aggregate.


-- Sam Carney

No comments:

Post a Comment