Solution / : Helens Calculation For Scores

Description: In order to calculate scores i need to add up 5 different scores from different fields, the take out the highest and lowest then add the remaining 3 up.

can anyone help?

Thanks

Working Under: 8

Solution Status: Beta

Pre-requisites:

Author(s): helenthebouncer

Date: 05/19/06

Credits:

Instructions / Other Info:

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

Hi, Hel!

Attachment will help you to quit your question.

Now we finished working and go home. I will back on mondey. If will be necessary i will continue.

In the field A you see your fields by sorting order, this must help you.

aaa.zip

How about simply:

Sum ( f1 ; f2 ; f3 ; f4 ; f5 ) - Min ( f1 ; f2 ; f3 ; f4 ; f5 ) - Max ( f1 ; f2 ; f3 ; f4 ; f5 )

Of course, there's a question of what to do in case of a tie.

Hello,

I don't think that i have inputted it correctly into my database - as i have never done any calculations before in filemaker, I have attatched my database so you can see how i have tried to input your formula (and got it wrong somewhere!)

I would be very grateful if you could tell me where i am going wrong!

Thanks

Helen

p.s. - ok so i was going to add my database untill i realised i can't on this site - do you mind forwarding me your actual email address?

Hi Helen,

To see how to attach a file, read the [color:orange]Frequently Asked Questions under the [color:blue]HELP in the [color:blue]MENU BAR.

HTH

Lee

Lee,

Thanks, i am so new at this you must be cringing!!

I have atatched the database,

thanks

competitions.zip

Hi, Helen!

I dont know i understand you or no.

Such as i undersand fron your examples.

Look attachment. If such you may be can make it simply.

competitions.zip