3 Replies Latest reply on May 28, 2012 2:42 PM by ChiehSuaiTan

    creating calculation in filemaker



      creating calculation in filemaker




      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