Newbies Louise Posted July 24, 2000 Newbies Share Posted July 24, 2000 I need to create a formula that calculates a 7 day average for the month. That is the total of the first seven days 1-7 then 2-8, 3-9, etc. Can anyone help me? Link to comment Share on other sites More sharing options...
LiveOak Posted July 24, 2000 Share Posted July 24, 2000 Need a little more information: Are the day values in separate records? In the same record in different fields? Is the desired result an average for each seven days? An average of averages? Is this to be displayed on a screen or in a report? -bd Link to comment Share on other sites More sharing options...
Newbies Louise Posted July 24, 2000 Author Newbies Share Posted July 24, 2000 Thanks for responding so quickly. Yes each value is in a separate record according to the actual date. The desired result is an average for each seven days and I need to display this in a monthly report. Thanks again for your help. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8686 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