nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to show Dynamic decimal formatting of Amount in BIP Report excel(*.xlsx) format using RTF

Anil Pandey-Oracle

Expectation is to show the value to number decimal based on CCY value in Excel(*.xlsx) report format.
E.g. if CCY = CAD then number decimal value should be #,##0.00 else #,##0.000.

i am using below code to achieve it.
<?xdofx:if CCY_BAL = 'CAD' then (<?xdoxslt:pat_format_number(CCY_BAL, '#,##0.00', $_XDOLOCALE)?>)
else
(<?xdoxslt:pat_format_number(CCY_BAL, '#,##0.000', $_XDOLOCALE)?>)
end if?

Looks like xdofx and xdoxslt cannot be used together for any field to derive the value in BIP RTF template.

so looking for your help on the same.

Find more posts tagged with

Submitted

BI Publisher

BI Publisher Data Models

Report Layouts

Report Output

BI Publisher Report Templates

Status: Submitted

Comments

Lucky Sharma

<?xdoxslt:ifelse(CCY_BAL = 'CAD',then (<?xdoxslt:pat_format_number(CCY_BAL, '#,##0.00', $_XDOLOCALE)?>,(<?xdoxslt:pat_format_number(CCY_BAL, '#,##0.000', $_XDOLOCALE)?>))?>

Not sure about the syntax as I cannot confirm in the current system I am using.

Let me know if it works

Anil Pandey-Oracle

Hi Lucky,Thanks for your input

The above syntax has not worked. Below is the screen shot for your reference.