Average during one month

[Anderss]

I have a date field (YYYY-MM-DD) and quantity field (Number). I would like to get an average field which will be the average of the quantity field of the month. When a new month starts the average should then be for this month. also when it is a change of year the average should be for example jan 2011. Could anyone help me with this calcutation ??

munad.fmp7.zip

[comment]

Maybe this way?

munad+.fp7.zip

[Raybaudi]

Hi comment

does not suffer too much of the found set to be a reliable average?

I would prefer a self join by the same calculation field.

MontlyAverage.zip

[comment]

It depends. In general, I follow the advice given here:

http://fmforums.com/forum/topic/42523-showing-count-of-value-list-items/page__p__201125#entry201125

[Raybaudi]

Thank you for that link.

[Anderss]

Thank a lot for your inputs, this helped me a lot.