Using the Decimal Formatting Feature

Oracle BI Publisher 11.1.1.7 and forward can dynamically format JD Edwards decimal amounts based on transaction and company currency. Data for a zero-decimal currency will display amounts with no decimals, whereas data for two-decimal currencies will display amounts with two decimals.

The dynamic format masking feature in BI Publisher 11.1.1.7 and forward creates additional decimal masking data, which is sent to Oracle BI Publisher's Layout Editor. The system automatically creates masking data for every decimal column in the data set. You can edit a data item's default decimal format in the Layout Editor to display the data on a report with a different decimal format.