BI Publisher wrong percentage value in XML

Andrew2009

Well Known Member
I see this strange behavior. I have the following two values for a field (MATH03) with display as % in JDE

103.47
97.92

In the XML, the values appear as below

103.47
.9792

And this is how it displays in Excel. My output is Excel

97.92%
10347%

Do you know why the value 103.47 appears wrong in XML and how to fix it?

Thanks
 
MATH03 is just display decimals of 2. It doesn't actually have any decimals in it's value

So it's telling you the truth actually

Just like LNID may look like 1.000 but it's actually 1000 on the database
 
Back
Top