FormatNum function

[Former Member]

Hi

when we will use FormatNum node function ?? what is its use ??

Thanks

kumar

[Former Member · Accepted solution]

Hello palnati,

Calculations (Add,Multiply,etc..) are performed with Java Float Precision

Trailing Zeros in result are truncated Eg : 5.6-0.6 = 5

To keep the Trailing Zeros use the FormatNum Function.

And if you want the do the Padding we use these Function.

Regards

Prasad

[Former Member]

Hi Palnati,

formatNum is not a node function..it's an Arithmetic function.

Regards,

Ramana Kumar. A

[Former Member]

Hi

Incase if u what to get the output in particular format

then we will go for this formatnumber.

e.g:

2 -> 00002

23 ->00023

You can mention the pattern type in the properties.

Regards

Yuga

[Former Member]

Hi palnati,

FormatNum Converts a Integer according to a pattern that you define using the function properties.

Examples

input a = 123 then you need 000123.

a -- formatnum(give the format 000000) --b

for example if you want commas after 3 numbers

you just use input -> number format->output

Ex: 1234 ->000,0->123,4

see here to get more examples

http://java.sun.com/j2se/1.3/docs/api/java/text/DecimalFormat.html

check these threads

https://forums.sdn.sap.com/click.jspa?searchID=5851686&messageID=3138012

Regards

BILL

<b>**reward with points if it helps u!!!</b>

[Former Member]

if you have input like 1,2,3 4 and you want output like 0001,0002,0003 etc then you use format number.