Reg: UDF for removing values after decimals

[former_member189440]

HI,

Please help me on the below issue,

I need an UDF for the follwing requirement,

as my input value is 12354.12354875 then the result will be like 12345.123,

After deceimal it should get only 3 values.

Please help me points will be awarded.

Edited by: UDAY on Apr 5, 2010 3:56 PM

[stefan_grube]

> I need an UDF for the follwing requirement,

> as my input value is 12354.12354875 then the result will be like 12345.123,

should the values be just truncated? not rounded to ...124 ?

[former_member189440]

yes its needed to be truncated only not rounded.

[former_member200962]

>

> yes its needed to be truncated only not rounded.

In that case even the standard function FormatNum can also help.

Regards,

Abhishek.

[Former Member]

Hi,

try this you don require an UDF.. Format number wil do good

http://wiki.sdn.sap.com/wiki/display/HOME/MessageMappingFormat+Number