Percentage Field That Handles Input For A Percentage As A Decimal Or Whole Number

Percentage Field that handles input for a percentage as a decimal or whole
number. Field Properties needs to be Type: Number & Percentage (Value*100)%.
Default Value event = 0.
Formula is placed in the Input Translation event.
Replace fieldname with the name of the field that will be held in temporary
variable i.
If the input value is not a number Zero is returned. Otherwise check to see if
the value is greater than 1. Decimal numbers are displayed as percentage values
correctly. 1 is displayed as 100%, and numbers greater than 1 are devided by
100 to get a decimal value that will display correctly. So .02=2%, .2=20%,
2=20%, 02=2%, 200=200%
This was first published in November 2000

Dig deeper on Domino Resources



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...