Categories
- All Categories
- 71 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- 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