Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Submitted
123
Views
2
Comments
Anil Pandey-Oracle
Anil Pandey-Oracle Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

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.

 t.gif

 

 

Tagged:
1
Up
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 Pandey-Oracle
    Anil 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.

    image.png