# Helens Calculation For Scores [Beta-8]

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

## Recommended Posts

• Newbies

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.

##### Share on other sites

Hi, Hel!

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

aaa.zip

##### Share on other sites

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.

##### Share on other sites

• Newbies

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?

##### Share on other sites

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

##### Share on other sites

• Newbies

Lee,

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

I have atatched the database,

thanks

competitions.zip

##### Share on other sites

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

##### Share on other sites

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

## Create an account

Register a new account