differe sum of amount is showing in excel output
Hi All,
XML Data template.
I have column ROUND(quantity_received,11) Order_Amt
<group name="G_Data" dataType="varchar2" source="Q_lines">
<element name="Line_Total_Amount" dataType="number" value="LINE_AMOUNT"/>
And in report level
| <element name="TOTAL_AMOUNT" | value ="G_DATA.LINE_AMOUNT" function="SUM()"/> |
Sample
Line_Total_Amount
| 75591 |
| 73463.5 |
| 69301 |
| 67932 |
| 74726.4 |
| 73304 |
| 67913.5 |
| 73304 |
| 68006 |
| 73304 |
| 192 |
| 180 |
| 47.16 |
| 144.6 |
In the rtf template defined in out of the group <?TOTAL_AMOUNT?> number format: 0.00
so
if i sum all the lines amount it is showing 3093811.17
But the TOTAL_AMOUNT column showing in the xml data tag as well as Excel output 3094350.34
can u please help me on this?
Thanks