Exp Function not working how I want it too – help please!
I am transporting a formula from excel to filemaker and up to a point everything is fine. There is 1 line that is not returning the result I am after.
the line is:
30 * Exp ( - ((( z - 275) / 25 ) ^ 2 ))
the value of "z" is 45.2070721 in this case, and the above function should return a value of 6.089.
I think it is getting stuck on the "-" in the brackets. This function works fine in excel, but not here. The excel formula looks like this:
If anyone has any ideas I would be most greatful since this is one of the last of 20 lines in a formula.