AnsweredAssumed Answered

creating calculation in filemaker

Question asked by ChiehSuaiTan on May 26, 2012
Latest reply on May 28, 2012 by ChiehSuaiTan

Title

creating calculation in filemaker

Post

Hello,

 

I am new to Filemaker and trying to migrate my database from Excel to FM after hearing all the great reviews about FM. I have no problem writing complex formula on excel but I stumble when using FM. Is there a "power" function or ^ function in FM? specifically, I am trying to do this calculation in FM: 

estimated Cr = (75/ (race*186*gender*age^-0.203))^-(1/1.154), where race =1 ( for white), 1.21(for non white), gender = 1( for male), 0.742(for female).

I have set up the necessary fields in FM but couldn't figure out writing the calculation. Can somebody please enlighten me or point me in the right direction?

I am using FM pro 11 currently as my mac book is of an older OS.. 

Thanks in advance

 

Outcomes