Jump to content

Average an Averaged Sub-Summary?


WF7A
 Share

This topic is 2519 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Greets, all:

 

I'm creating a report where I need to average each heading's average but I'm scratching my head raw trying to get it to work. (Please refer to the attached.)

 

For example, under Content Specialist, I want to average 2.13 and 2.71 which should equal 2.42 (4.84 / 2 = 2.42) but FileMaker has other plans and spat out 3.03...which is a result of taking all the gazillion records in the found set and averaging them out instead of averaging just the two (sub-summarized) numbers.

 

I "get" that I need to create a new sub-summary but how should I code the (new) summary field so I get the average of the items listed under each heading?

 

TIA for your help!

Rich

post-76798-0-52050100-1409960493_thumb.p

post-76798-0-89235100-1409960507_thumb.p

Link to comment
Share on other sites

Yup, it's 3.13. I didn't have my reading/computer glasses handy when I wrote that. Sorry!

 

Y'know, I asked the very same question but that's what my boss wants so that's what she gets. :|

Link to comment
Share on other sites

Well, she's not my boss, so that's not good enough for me. Perhaps you should show her the following example:

 

A school has two classes. There are 9 students in the first class and all of them have a perfect score of 100. The other class is a remedial class; it has only one student with a score of 0.

 

According to your boss, the overall school average should be calculated as follows:

 

• Class 1 average = 9 * 100 / 9 = 100;

• Class 2 average = 1 * 0 / 1 = 0;

School average = ( 100 + 0 ) / 2 = 50

 

which is of course a complete nonsense, because in fact the overall school average is = ( 9 * 100 + 1 * 0 ) / ( 9 + 1 ) = 90 i.e. "a result of taking all the gazillion records in the found set and averaging them out instead of averaging just the two (sub-summarized) numbers".

 

Now I'll make you a deal: show me a case where the average of averages has a meaning and I'll show you how to calculate it.

  • Like 1
Link to comment
Share on other sites

This topic is 2519 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.