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