round oFF

[Former Member]

input string

xxxxxxx.xxx

after decimel point always 3 digits are coming.. i need to round off these 3 digits to 2 digit

output

xxxxx.xx

i tried with Format number (.##) but it wont work coz.. if i/p 456.000 then its sending 456

but i need 456.00

also if i/p 0.xxx i need 0.xx

can anyone help...

[markangelo_dihiansan]

Hi,

I've tried using formatNumber with parameters #.##, it is indeed returning a value of 456 from an input of 456.000. What you can do is to replace the # with 0. The mapping should now look like this

inputNum --> formatNumber: 0.00 --> target

This should work

Regards,

[Former Member]

Hi,

You can use the formatnumber std function like this:

Input -> FORMATNUMBER(with property set to 00000.00)> output.

It will definitely owrk even for XXX.000 it will provide the ouput as XXX.00

Try this..

Regards,

Nithiyanandam

[former_member181985]

Use this UDF

input field(a)>UDF>output field

return(a.substring(0, a.indexOf(".") + 3));

- Gujjeti.