Skip to Content

Regarding Standard function

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 01, 2008 at 06:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 06:09 AM

    FormatNum

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 06:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 06:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 01, 2008 at 06:57 AM

    Hello

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

    FormatNum wont work.

    Add comment
    10|10000 characters needed characters exceeded