0

I have the following values that are calculated using the RunningValue() function.

Data

This is the Expression used.

=RunningValue(Math.Abs(SUM(Fields!paid_amount.Value)/fields!adv_amt.value), Sum, "PercentageFunded")

I need to create an average for these values by row but I've been unsuccessful. How do I create an aggregate of RunningValue outside of the group?

dimiguel
  • 1,429
  • 1
  • 16
  • 37
  • I've tried AVG(RunningValue()) but I get an error. AVG(SUM()) also does not return the correct values. – dimiguel Aug 05 '14 at 19:35
  • You are trying to populate the "Average" column in your screenshot, correct? In that case, you could try averaging the ReportItem values in each row. – Tab Alleman Aug 05 '14 at 19:51

0 Answers0