Regarding Standard function

[Former Member]

Hi

I am getting 6 digit number from the source.

ex 103924

in the target i want 1039.24

Please tell me is there any standard function for this and tell me how to use it.

regards

venkat.

[former_member214364 · Accepted solution]

Sorry Venkat,You cant do this with FormatNumber standard function.just follow others solutions.

Cheers,

Jag

Edited by: jag on Sep 1, 2008 5:02 PM

[hemant_chahal]

Hello

you can use "div" (Arithmetic)function also and put second argument as 100.

FormatNum wont work.

[Former Member]

Hi,

You can use the FormatNumber API and formulate the no as per your requirment.

Or Best way if the no of digits are not fixed then Multiply the Source field by 0.01

Source Field--> Multiply (0.001 Constant) --> Target field

Thanks

swarup

[Former Member]

Hi,

for your requirement you need to go for below logic...

X(6 Dig No Field)Substring(0-4)(In text Function)-Concat(In text Function)(use . Delimiter)--Target

X(6 Dig No Field)Substring(4-2)(In text Function)-

Regards,

Prakasu

[Former Member]

FormatNum