AnsweredAssumed Answered

Calculating Formulas

Question asked by spinny on Mar 19, 2010
Latest reply on Mar 19, 2010 by comment_1

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!

Outcomes