Oracle Communities

Oracle Analytics and AI

Child Item

Issue with rounding in RTF Template Formula

In my RTF template, the formula <?format-currency:INVL_UNIT_PRICE_VARIANCE; xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> rounds values to 2 decimals by default.

For example, if INVL_UNIT_PRICE_VARIANCE is 0.006 in the data model, the output becomes 0.01 after running the template.

Adjusting the format to ##0.0000 displays 0.0100, but I need it to show the value with rounding of 4 decimals using the format-currency tag.

Format currency should not disturb 2. rounding should be 4

Can you pls help on this? Thank you!

Find more posts tagged with

Reporting

BI Publisher

BI Publisher Data Models

Customizing Reports

BI Publisher Report Templates

Accepted answers

Sumanth V -Oracle

@Pooja K-Oracle - This appears to be a known issue, as similar concerns have been raised in the following bug report:
Bug 36861747 - DAILY CURRENCY CONVERSION RATE REPORT ROUNDING TO 2 DECIMALS.
Please follow the bug; it may help resolving the issue. Thanks!

All comments

Sumanth V -Oracle

@Pooja K-Oracle - Please use <?xdofx:round(number [, integer])?> instead of <?xdoxslt:round(number [, integer])?> in the template layout and test the issue. Thanks.

Pooja K-Oracle

Hi @Sumanth V -Oracle ,

Greetings of the Day!!

PFB responses
<?format-currency:INVL_UNIT_PRICE_VARIANCE; xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> --original tag<?format-number:xdoxslt:round(INVL_UNIT_PRICE_VARIANCE,4); xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> -- rounding to 4 decimals with format-number as expected but with number fomat not format currency<?format-currency:xdoxslt:round(INVL_UNIT_PRICE_VARIANCE,4); xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> --rounding to 2 by default due to formart currency usage<?format-currency:format-number:xdoxslt:round(INVL_UNIT_PRICE_VARIANCE,4); xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> --returning blank value<?format-currency:format-number(xdoxslt:round(INVL_UNIT_PRICE_VARIANCE,4)); xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> error<?format-currency:xdofx:format_number(xdoxslt:round(INVL_UNIT_PRICE_VARIANCE, 4)); xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> error<?format-currency:format-number:xdoxslt:round(INVL_UNIT_PRICE_VARIANCE,4); xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> returning blank value<?format-currency:xdofx:format_number:xdoxslt:round(INVL_UNIT_PRICE_VARIANCE, 4); xdoxslt:get_variable($_XDOCTX,'invCurrCode')?> returning blank value

Thanks & Regards,

Pooja Kharge

Sumanth V -Oracle

@Pooja K-Oracle - Please let us know if you are using Fusion Applications [OTBI] BIP.

Pooja K-Oracle

@Sumanth V -Oracle ,

It is a BIP report i fusion applications - reports and analytics with datamodel -sql query involved in it

Sumanth V -Oracle

Pooja K-Oracle

@Sumanth V -Oracle ,

Okay sure, Checking.