• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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
 

johndanter

Legendary Poster
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
 
Top