Average of accumulated values, per day

Wed, 07 Aug 2013 17:05:48 GMT

Hi everyone,

I have a problem with the average of accumulated values, per day, in a pivot table.

For example:

Date Values

01/08/2013 - U$400,00

02/08/2013 - U$500,00

03/08/2013 - U$300,00

04/08/2013 - U$400,00

05/08/2013 - U$400,00

06/08/2013 - U$500,00

Ok. And now, I want a expression to get the average of accumulated values, per day.

Like this:

Date Values Average of Accumulate Values

01/08/2013 - U$400,00 U$400,00

02/08/2013 - U$500,00 U$450,00

03/08/2013 - U$300,00 U$400,00

04/08/2013 - U$800,00 U$500,00

05/08/2013 - U$400,00 U$440,00

06/08/2013 - U$600,00 U$500,00

See? The expression will be some like "Accumulated values in that month until that day / number of days until date I want".

I don't know if my explanation is clear, but it's something like that. In the example with values, are more clear.

How can I do that? Have some way?

Thank you!

Re: Average of accumulated values, per day

Gysbert_Wassenaar — Wed, 07 Aug 2013 17:13:07 GMT

Try: RangeAvg(above(sum(Values),0,RowNo()))

The average for 05/08/2013 is 480 afaict though, not 440.

Wed, 07 Aug 2013 17:17:14 GMT

Thank you man!!! Works perfectly!!