Kermy Posted May 15, 2001 Share Posted May 15, 2001 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 More sharing options...
birdman Posted May 16, 2001 Share Posted May 16, 2001 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 More sharing options...
Kermy Posted May 17, 2001 Author Share Posted May 17, 2001 Good idea, but I have no idea how to do this. =) Only a little beyond a newbie. Link to comment Share on other sites More sharing options...
Chuck Posted May 18, 2001 Share Posted May 18, 2001 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 More sharing options...
birdman Posted May 20, 2001 Share Posted May 20, 2001 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now