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

This can be done, but you don't want users who enter the data in decimal form to also have their data divided by 100. If 100 is the largest possible value that they can enter, use this auto-enter calculation on this number field:

IF ( self > 1 ; self / 100 ; self )

and clear the "do not replace existing value..." option.