### Title

Calculating Formulas

### Post

Hi All,

In my recruiting database I am trying to calculate an academic index. Part of the Academic index is based on a number of points you get for your GPA. This differs depending on what your GPA is.

What I am trying to do is input a GPA to the GPA4 field. I then want the Academic Index field to look at the GPA4 field, compare it to a list of values and the points you get for each value in GPACALC table and return the score to the academic index field. In Excel the formula is:

=VLOOKUP(N6,AX4:AY34,2)

Where N6 is the GPA, AX4:AY34 is the cell references for the GPA's and the points you get for them and 2 is the number of columns in the array.

I had tried

Lookup ( GPA 4 , GPA4::_4GPA_SCORE : GPA4::_4GPA_POINTS )

Working on the same principal but I am guessing something is wrong with the way I am inputting it as it says it does not recognize the field!

Any help would be appreciated,

Andy

Mac OSX 1.6.2 filemaker newbie!

In your table GPACALC, create records for each grade range and correpsonding points. You should have a lower, upper, and points fields.

Then create a relationship from your main table to this table where:

GPA ≥ lower

GPA ≤ upper

Noe you can either put the points field directly on the layout or if indeed you want a lookup to put into another field, then your lookup based on this relationship should work.