My Oracle Support Banner

E1: RDA: How to Add a Leading Zero for Value Less Than One? (Doc ID 655563.1)

Last updated on JANUARY 13, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.


There are many standard reports that have columns with values less than one showing no leading zero in front of the decimal.  
For example, numeric field PNAOW, UPRC and HRW when included in the report and run, the field will show .20 rather than 0.20 if it has a decimal less than 1.

Changing the display edit code in the RDA property for the numeric field and trying all possible edit codes still does not show the leading zero for a decimal value less than zero.

Is there a way to show amounts that are less than one with a leading zero? 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 When value is not zero
 When value is zero

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.