on 09-12-2008 11:15 AM
Hi All,
I am new to XI
I have a field Decimal.I am getting 4.14E10 value from Source System.I need to Convert it to Decimal like 414000000.00(in this format)
Can any one help on this?
thanks,
pachika
write udf to convert from exponent format to decimal fromat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
not good
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use type DEC with length 9 and 6 decimals
OR
You can use BAMNG data elemnt
(Use reference table EBAN ref. field MEINS)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You could achive with standard API FormatNumber in arithmatic category of Mapping.
here you could select the format that you are expecting as output as ####.### etc
source >FormatNumber->target
refer
format-number function
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.