12 Replies Latest reply on Apr 1, 2011 12:02 PM by RickWhitelaw

    Need help calculating data entered into field

    CarrieB.

      Title

      Need help calculating data entered into field

      Post

      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!!