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 AI and Analytics

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.

Top Leaders

Top Ideas

Clarification/Correction of Identifying PO Field in Payables Invoices-Transactions Real Time SA OTBI
Issue Description The Identifying PO field is a header-level attribute, but it is currently displayed under Distributions → Invoice Distribution Details → Purchase Order Information in the Payables Invoices – Transactions Real Time subject area. When an invoice has multiple POs, the same header-level PO can be repeated…
Provide Email Delivery and Bounce Status Tracking for BI Publisher Bursting Emails
BI Publisher bursting currently reports an email delivery as successful once the email has been processed and sent from Oracle. However, there is no customer-accessible functionality in Oracle Fusion/BI Publisher to determine whether the email was subsequently delivered, rejected, bounced, or returned as undeliverable by…
Copy functionality for reports to be granted independently within report security permissions
ERP: Ability to provide copy functionality for reports within report security permissions or manage privileges without providing full edit / write access. Currently, it does not appear that 'copy' access can be given independently.
FDI report/object security to grant Copy as an independently grantable permission
FDI: Ability provide copy functionality for reports within report security permissions or manage privileges without providing full edit / write access. Currently, it does not appear that 'copy' access can be given independently.
Restriction of Data Source in reports and analytics while creating Data Model
Currently any user account having access BIPDataModelDeveloper role is providing the ability to see any sensitive information in the Oracle fusion irrespective of data restrictions placed in the front end through role assignments. User while creating a data model can see any HCM data like (Payroll details, DOB, SSN, etc.)…