# How to calculate monthly average

1. ## How to calculate monthly average

Top table is how I think the monthly average should be calculated. Bottom table is how it is currently been calculated at my work place. As you can see the overall grade is not the same at the end of the month, eventhough I am using the same exact numbers. Can anyone help me find the correct way?

2. ## Re: How to calculate monthly average

overall grade is not the same
From where you are comparing .. I see both the overall all grades (which are in Y11 and Y17) are using different numbers and hence the average will be different. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

3. ## Re: How to calculate monthly average

But do you see on the top table I'm calculating the weekly average first and then at the end of the month I get the weekly average and with that generate the monthly average? And on the bottom table 2nd week's average is added to the first week's average, third week's average isadded to the 2nd and 1st week's average and so on? And at the end of the month that's causingthe overall grade to be different?

4. ## Re: How to calculate monthly average

Not sure.... are you calculating average of average?

As you can see the overall grade is not the same at the end of the month, eventhough I am using the same exact number
Best check would be to list down the numbers which are getting averaged in both the scenarios and then compare if both the list is same

Regards,
DILIPandey

<click on below 'star' if this helps>

5. ## Re: How to calculate monthly average

Yeah! does what I thought in the second table first week's average is already calculated and then second weeks' average is averaged again to the first weeks' average and I dont think this is the correct way to do it. Right?

6. ## Re: How to calculate monthly average

yes..

Regards,
DILIPandey

<click on below 'star' if this helps>

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1