Problem with FormatNum function

[Former Member]

Hi,<br><br>

I have a simple mapping where a constant value is map to a FormatNum function and is map to a target field. The constant value is 123456789123456789 (18 numeric characters). The parameter for the FormatNum function is 00000000000000000000 (20 zero characters). When I check the result, I get a value of 0012345678912345678<font color="red">4</font>. When I reduce the number of characters for the input value from 18 characters to 17 characters, the FormatNum is working properly. I even change the parameter of the FormatNum to 00000000000000000### (17 zero characters and 3 number sign characters) and I still get an erroneous result. I also tried changing the value of the last character of the input constant from 9 to any other value and the result always ends with 4. Does anybody have an idea what is causing this? Is there a OSS note about this? Or is this a problem of the jdk that we are using?<br><br>

I am making use of XI 3.0 SP18. <br><br>

I know this can easily be solve by writing a user-define function that pads zeroes in front of the input value, but I am just wondering what is causing this problem. Thanks in advance to anyone who responds.<br><br>

Regards,<br>

Elbert

[Former Member · Accepted solution]

check this

/people/thorsten.nordholmsbirk/blog/2006/08/25/new-arithmetic-and-statistical-functions-in-message-mappings-in-sp18

regards

sreeram.g.redddy

[prabhu_s2]

check with: http://help.sap.com/saphelp_nw04/helpdata/en/43/c4cdfc334824478090739c04c4a249/frameset.htm

[Former Member]

elbert,

can you try sending blank valueand u should get 20 zeros output.

regards

sreeram.g.reddy