Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Summing up Grades


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

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8568 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
×
×
  • Create New...

Important Information

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