How to avoid round of the value in mapping

[Former Member]

Hi!

I am trying to pass in mapping value 999999.999, but XI rounds it to 1000000.

How can I avoid this?

I tried to change types of field in Data Type: string, float, same problem.

Any help appreciated.

[Former Member · Accepted solution]

Hi,

try it with BigDecimal:

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

Regards

Patrick

[Former Member · Accepted solution]

Thanks, this solved the problem.

"Format number" didn't work.

[Former Member]

Unless you have used a function like round off in your mapping, XI does not do this automatically. Make sure the input is correct.

[Former Member]

Hi Dani,

Please use the "format number" Arithmetic function for the corresponding fileds having number format as : "000000.000" and decimal separator as ".".

Regards,

Madhu

[Former Member]

Hi,

try using this function in message mapping

FormatNum

Converts I according to a pattern that you define using the function properties. The possible patterns are the same as in the Java class java.text.DecimalFormat.

Regards,

Kai