Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

96
Views
2
Comments

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.

 

 

1
1 votes

Submitted · Last Updated

Comments

  • Lucky Sharma
    Lucky Sharma Rank 2 - Community Beginner

    <?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 Kumar Pandey-Oracle
    Anil Kumar Pandey-Oracle Rank 3 - Community Apprentice

    Hi Lucky,Thanks for your input

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