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