BI Publisher (MOSC)

MOSC Banner

differe sum of amount is showing in excel output

edited Feb 24, 2017 10:21AM in BI Publisher (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center