E9.2 BI Publischer sum wrong format number

[gc74]

I All.
I have an XML file with tag field AWB_GRWT_ID18 and some values

example:
1.6872
1.5847
.9876
...
etc..

in template put this field on for each and finally sum de values with ?sum(AWB_GRWT_ID18).
This field was formatted as #,##0.00 but wnen generate the sum result was wrong.
For example I have 15,180,00 .. double comma!!! Why?

 

[alfredorz]

Hi @gc74,

What is locate BIP config? It's happen in your local machine or a server to? the number is in a field or a tag? could do you calculate the sum in a report and get in bip from xml? could you give us more info or attachment template and xml?

Regards.

 

[gc74]

local BIP
in a tag
yes, but I wanted to use the XML functions.

 

[alfredorz]

look at https://docs.oracle.com/middleware/...665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2554 and https://docs.oracle.com/en/middlewa...tml#GUID-DCC48F17-7894-41C9-8C26-1C4CFB88F350 and Oracle Support Document 654949.1 (E1: XMLP: How to Format Numbers in BI Publisher RTF Template) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=654949.1

Do you use <?format-number:number_var;'##,##0.00'?> or <?format-number:number_var;'9G999D99'?>

 

[gc74]

thanks for documentation. I have solved. Thanks

 

[alfredorz]

I'm glad to hear it.
Kind regards.