Sunday, March 25, 2012

Cannot perform needed expression

Is there a work around for trying this in my footer table field in my
SSRS 2005 report?
=SUM((Max(Fields!FeeGoal_AZ.Value) / (Fields!FeeSchedule.Value) * 100)
doesn't allow aggregate functions inside SUM...but I need to do this!Try creating a calculated field called MaxGoal using
=Max(Fields!FeeGoal_AZ.Value) as the expression, then doing
=SUM((Fields!MaxGoal.Value / Fields!FeeSchedule.Value) * 100)

No comments:

Post a Comment