Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
.RTF TEMPLATE 0,00 instead of ,00 inside of a sum group
Summary
.RTF TEMPLATE 0,00 instead of ,00 inside of a sum group
Content
Hello , I have a requirment from a customer that want that the numbers (when <1 ) appear in his invoice like 0,77 instead of ,77.
This is a vat table that have a sum group like this:
<?for-each-group:Tax_Summary_Lines_Section_S8;./Summary_Tax_Rate_ID4?><?sort:current-group()/Summary_Tax_Rate_ID4;'ascending';data-type='number'?>
<?format-number:(sum(current-group()/Summary_Taxable_Amt_ID8));'999G999D99'?>
<?end if?>
When the value is less than 1 i always get the output of , per example , ,70 insted of 0,70.
This format in a normal for each works fine in this cases so i think that its something related with sum group funcion
Someone can help me?
Thanks in advance.
Answers
-
Try something like this <?xdoxslt:format_number(SALARY, 2, ',', ',', 'en-US')?>
If it doesn't work could you post a sample XML and RTF, also what version is your BI publisher?
0 -
Hi,
Instead of format
<?format-number:(sum(current-group()/Summary_Taxable_Amt_ID8));'999G999D99'?>
you can use
<?format-number:(sum(current-group()/Summary_Taxable_Amt_ID8));'999G990D00'?>
Regards,
Brajesh
0