Cumulative Average

[yadhunandhanan]

Hi Team,

I need your help. I have a task that i need to find cumulative average for each month.

But in my data each month have different count of date,

i.e., In Jan only 10 days value are available and Feb only 21 days value are available in my data source.

How to find cumulative average? Please help me to solve this.

Thanks in advance.

[sunny_talwar]

How about this:

RangeAvg(Above(Sum(Value), 0, DayField))

[yadhunandhanan]

Thanks Sunny.

[sunny_talwar]

Is it working?

[yadhunandhanan]

Yes its working.

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .