Oracle Analytics and AI

Paulo Duarte

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.

Sherry George

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?