Summing up Grades

[Kermy]

Hi, another question:

For each class that's listed I want to sum up the grades but I only want to sum up the grades that aren't F, W, I, etc etc. So I only want ot sum up: A, A-, B+, B, etc. And add up the grades. I'm using just regular sum right now and that includes F, W, I which I don't want. Anybody know how to do a calculation for this?

Henry

[birdman]

Henry,

A solution would be to create a calculation file who's result would be either a 1 or a 0 depending on what the grade was given. Then have a field that generates the sum of the new calculation field.

Hope this helps.

[Kermy]

Good idea, but I have no idea how to do this. =) Only a little beyond a newbie.

[Chuck]

Create the following fields as calucations with number results:

Is_A = Grade = "A"

Is_A_Plus = Grade = "A+"

etc.

Don't use field names like Is_A+ as FileMaker won't let you use such fields in calculations.

Then create summary total fields like this:

Total_of_Is_A = Total of Is_A

Total_of_Is_A_Plus = Total of Is_A_Plus

Chuck

[birdman]

Hi,

I was thinking of a field called Grade_Calc (or something like that) and using a calculation similar to the following:

Case(Grade="A+",1,

Grade="A",1,

Grade="A-",1,

Grade="B+",1,

continue like this until the end

Grade="F",0,

Grade="W",0,0)

The Case function is similar to but not identical to the IF function. It is used to evaluate an argument ( in this case is the Grade= A) and then puts in the corresponding answer depending if the argument is true or false.

Then create the summary field based on the Grae_Calc field.

Hope it helps.