Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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