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.

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.

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.