Calantha

Nevermind! I've figured it out. The weightings weren't working properly and now they are! I apologize for all of the trouble! I appreciate your help so much, thank you!

Sure: I've typed these numbers into my database: 68, 75, 85, 52, 97, 47, 89, 87, 92, 93, 85, 81, 94 the resulting GPA is 3.30 if I type the numbers as: 68.0013, 75, 84.89, 52.36, 97.1, 47, 88.6, 87, 92.2, 92.8, 85, 81.03, 94 the resulting GPA is: 3.12 Utilizing the equation provided by the users above the GPAs sometimes differ extremely, for example: 1.13 when it should be 2.12. There is another equation that follows after in order to get the proper weighting and decipher the GPA however, which is all of the resulting GPA calculations added and divided by 22.

I don't know why, but it still isn't working... Using values with decimal points gives me a GPA of 1.13 Using the same values without decimals points gives me a GPA 2.12 ??

Actually that formula won't work because for example, let's say the mark is 66.9. It will run through the calculation and sees that 66.9 is < 67 therefore it will assign the value 2.00... however, 66.9 rounded is 70 and should be assigned 2.33...

Ok. I've tried this calculation and it still doesn't seem to work... Let (n = (GetAsNumber(Round(ACOU Marks S1; 0))); Case( n < 40; "0"; n >= 40 and n <= 53; "0.25"; n >= 54 and n <= 56; "1.00"; n >= 57 and n <= 59; "1.33"; n >= 60 and n <= 62; "1.67"; n >= 63 and n <= 66; "2.00"; n >= 67 and n <= 69; "2.33"; n >= 70 and n <= 72; "2.67"; n >= 73 and n <= 76; "3.00"; n >= 77 and n <= 79; "3.33"; n >= 80 and n <= 84; "3.67"; n >= 85 and n <= 89; "4.00"; n >= 90 and n <= 100; "4.33")) Ideas?

Yes, that is what the problem is. The GPA calculation wasn't accurate because 73.3 is technically = to 73 but the calculation views it as greater than 73. This is why I would like to have the numbers rounded so there are no decimals points and use the calculation without decimals. I will try the round function above, and also, thank you for the great calculation that you offered. I will be using that as well! Thank you all for your help!

Figured it out! 24.5 = 25 Although it shows as 25 when rounded, it is not rounding and therefore calculating it as less than 25. Is there a way to automatically round numbers in FileMaker?

Hi there! In our school we do all of our GPA calculations for transcripts within FileMaker. I imported all of the marks from Excel. The calculation is something like: If(GetAsNumber(Marks S1) < 40; "0"; If(GetAsNumber(Marks S1) >= 40 and GetAsNumber(Marks S1) <= 53; "0.25"; If(GetAsNumber(Marks S1) >= 54 and GetAsNumber(Marks S1) <= 56; "1.00"; If(GetAsNumber(Marks S1) >= 57 ... etc. I've noticed however that it is not calculating properly and the only way it does calculate properly is if there aren't any decimal places. Why would having decimal places effect the calculation? 24.3 is less than 50 whether it be 24 or 24.3, but when it is 24.3 it doesn't recognize it at all! Any help would be greatly appreciated!

Well I thank you for your help. I'm not a database developer, in fact, I know little to nothing about them but have been told to build our database... I just picked up a FileMaker 8 book which may be helpful. Again, thank you!

And now that I'm attempting to implement it, it seems I do not have a field corresponding to the "value" field in the example.

One last question: what if I do not have a value list for an item. For example inquiry date. If I want to summarize inquiries per month and the inquiry date field is entered upon inquiry, not from a drop down. Is this a case where you have to create an individual calculation for each one? This is what I have already and it works fine. I'm just curious if there are other ways.

Great, thanks. I'm actually using 8... I just haven't changed it yet. Oops.

Thank you! I love learning new things like this. Could you give me an example of what the calculation would look like? For example, i have a value list "Source" which contains Google and Yahoo. I want to know how many people used Google and how many people used Yahoo.

Thank you. I have read that topic a number of times and still fail to grasp the concept. When I look at the file I don't understand how you manage to have so little fields for 7 different types of payment...

Hello again, I am once again tackling this problem. I recently solved it by creating a flag and then creating a summary. ie. GoogleFlag source of awareness = "google" GoogleSum Total GoogleFlag This has worked fine but I have over 50 different sources and creating the flag and then the summary takes a lot of time. I attempted the previous version that you mentioned, creating a global field with google and then a count field. But if I have over 50 sources of awareness would they not all require their own table? In some cases where I would like to summarize, example: by country... there are so many countries is there an easier way to do this? Thank you!

Interesting. It will take me awhile to wrap my head about that one and when I do I will try it out. Thank you for your help.

A multi-line key. Is that a key that has two references? I attempted to create a relationships from References RefID to the student database of RefID_1 and RefID_2 for both references but it didn't work...

I'm still stuck. Let me see if I can explain this properly. Databases involved: Student Database Schools Database Tables involved: Student School References Each student has 2 references. Each reference belongs to a school. 1 School can have multiple references (teachers referencing students), 1 reference can refer multiple students, 1 student has multiple references. What I need to accomplish: The reference table must be related to the Schools table so that I can see how many and which references come from which schools. Schools table shows me a list of all the references from that school. I would like the references table to show me how many students they have referred. So the reference table must be somehow related to the student database. The student database has to show me the information for the references which have referred that student. So: Schools contains: School Information List of References from that School References: Reference Information List of Students they have referred Students: Student Information Information of References (2) Is that clear? I've been fighting with this one. I've attempted a bunch of different things... the last of which was doing away with the references table and using the Students table to hold the reference information and then using a portal in the Schools table to list the references. The only issue with that is that one reference can refer multiple students, therefore the list would contact duplicates (which I don't want). All your help is very much appreciated. I stil love the value list idea!

Wow! That is awesome! Thank you!

Hello, I've been away from the forum for awhile attempting to figure things out on my own, but I've run into another roadblock. I have two databases 1) Student Database 2) Schools Database (with an Information tahle and a References table) The student database includes all student information. The schools database includes information on schools our students have come from as well as contacts. When a student applies to our school they require two reference letters. These reference letters are often from teachers. In the student database there is an area where I enter the information of the references (name, school, email, phone, etc.). In the schools database I have a table which shows all of the information on the school, and another table which is for all of the references. The references are related to the schools table so that I know which references belong to which school, this is fine. However, what I would like to do is when I receive an application, I would like to enter the reference data in the student database and have that correspond in the reference table of the schools database. This seems easy enough. However, if I enter the reference data in the student database, it then shows up in the reference table in the schools database but how does it know what school it is from unless after that I go and look up the school ID number and enter it? Is there anyway I can do this without having to go look up the school's ID number? Or are you always supposed to know the ID numbers? I hope this was clear enough.

If I am understanding correctly (which I have my doubts that I am) the relationship::serial would necessitate serial numbers for each of my records? Because my records don't have serial numbers (i know, I know.. bad...)

Hello again, I'm back trying to accomplish this again. So far how I've seen it possible is to create one field that's a calculation, so something like this: If I wanted to see how many people became aware of us through google: if (awareness = "google", 1, 0) then creating a summary field which totals that field giving me a running total of how many people according to the if statement. Is this on the right track?

Well I found out the main problem, my form fields weren't global fields, however, my comment fields (which are text fields) do not work even when they are set to global fields...

Sorry, I guess that would help. The fields outside of ACOU are not setting... they are remaining blank.

Hi there, Quick background: I've created a form, the user entires info, hits submit, the info is copied to another layout and the form is then cleared. I have been setting each individual field (because I don't know of an easier way) and then clearing each individual field. I have done this and it has worked until now. The only difference I can see is that I have to go to multiple layouts for this script... Can someone tell me what is wrong here? It works for the first layout but not the others. For example: Go to Layout ["ACOU" (Student Eval)] Set Field [student Eval::ACOU_Material, Form::ACOU_Material] Set Field [student Eval::ACOU_Knowledge, Form::ACOU_Knowledge] Commit Records Go to Layout ["APIX" (Student Eval)] Set Field [student Eval::APIX_Material, Form::APIX_Material] Set Field [student Eval::APIX_Knowledge, Form::APIX_Knowledge]