AnsweredAssumed Answered

Need help calculating data entered into field

Question asked by CarrieB. on Mar 29, 2011
Latest reply on Apr 1, 2011 by RickWhitelaw


Need help calculating data entered into field


I'm sure this is an obvious question, but I haven't worked in FileMaker for a while. :) I'm trying to figure out how to take the data entered in a field and divide it by 100 automatically. Here's the details: I have a PMT calculation in the final field, but the user enters the amount, number of payments and interest rate in other fields. I have the interest rate field formatted as a percentage. As it is now, the user has to enter ".08" for it to show up as "8%". If they enter 8 in the field, it shows as "800%". 

Any suggestions? Thanks!!