Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 186 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 63 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to show Dynamic decimal formatting of Amount in BIP Report excel(*.xlsx) format using RTF

Expectation is to show the value to number decimal based on CCY value in Excel(*.xlsx) report format. so looking for your help on the same. | |
---|---|
|
|
---|---|
Comments
-
<?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
0 -
Hi Lucky,Thanks for your input
The above syntax has not worked. Below is the screen shot for your reference.
0