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