### Title

Calculations on new records

### Post

Please help!

I'm very new to Filemaker Pro on the mac and therefore this may be a simple query.

I have created a DB where some of the fields perform calcualtions based on entries elseqhere. THese all work correctly until I add a new record.

Although I input the information the DB fails to make the calcuations for the new record?

Please can you advise what I'm doing wrong

thanks

rewriting it into a Case function (and I removed the extra space ):

Case ( FFT AS 1="A" ; 60;

FFT AS 1="B" ; 50 ;

FFT AS 1="C" ; 40 ;

FFT AS 1="D" ; 30 ;

FFT AS 1="E" ; 20

)

And Here is an alternative to Case:

If ( PatternCount ( "ABCDE" ; FFT AS 1 ) ; 60 - ( Code ( Upper ( FFT AS 1 ) ) - Code ( "A" ) ) * 10 )

A third alternative is to not use a calculation at all for this but instead to set up a related table of values where the value in FFT AS 1 is used to match to a record in this "look up table". This last approach allows the user to modify what values are returned without having to redefine your calculation field--it becomes a data entry task instead.