Newbies Anderss Posted December 28, 2010 Newbies Share Posted December 28, 2010 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 Link to comment Share on other sites More sharing options...
comment Posted December 28, 2010 Share Posted December 28, 2010 Maybe this way? munad+.fp7.zip Link to comment Share on other sites More sharing options...
Raybaudi Posted December 28, 2010 Share Posted December 28, 2010 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 Link to comment Share on other sites More sharing options...
comment Posted December 28, 2010 Share Posted December 28, 2010 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 Link to comment Share on other sites More sharing options...
Raybaudi Posted December 28, 2010 Share Posted December 28, 2010 Thank you for that link. Link to comment Share on other sites More sharing options...
Newbies Anderss Posted December 29, 2010 Author Newbies Share Posted December 29, 2010 Thank a lot for your inputs, this helped me a lot. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4868 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now