Topic
3 replies Latest Post - ‏2012-10-12T06:07:21Z by SystemAdmin
SystemAdmin
SystemAdmin
6184 Posts
ACCEPTED ANSWER

Pinned topic UNZONE FUNCTION

‏2012-10-03T06:24:00Z |
Hi

I am facing issue with UNZONE function

My Input value is "123N" and the Output should be "-1235"
So i have taken the input field as Number Zoned and Sign Yes and Output i have taken as Number Integer and sign Yes

And in the output field mapping rule i mapped like
="UNZONE(Input Field)"

But its returing the output like 1235 its not returing the output with signed symbol

Any one please let me know how can i get the exact output
Thanks
Updated on 2012-10-12T06:07:21Z at 2012-10-12T06:07:21Z by SystemAdmin
  • gspvish
    gspvish
    18 Posts
    ACCEPTED ANSWER

    Re: UNZONE FUNCTION

    ‏2012-10-04T17:45:23Z  in response to SystemAdmin
    Pl upload the map (PI zip)
  • SystemAdmin
    SystemAdmin
    6184 Posts
    ACCEPTED ANSWER

    Re: UNZONE FUNCTION

    ‏2012-10-08T06:15:36Z  in response to SystemAdmin
    Hi,

    Take ur input as Text and output as Number type integer with Sign leading(-).Then try the unzone function in the output u will get the result as expected "-1235".

    Cheers.!
    • SystemAdmin
      SystemAdmin
      6184 Posts
      ACCEPTED ANSWER

      Re: UNZONE FUNCTION

      ‏2012-10-12T06:07:21Z  in response to SystemAdmin
      Hi
      thanks for reply.

      suppose my input is -123 and now the output should return -123

      will this scenario works

      and i have one more scenario

      This is the input "123N" and the output is -12.35

      how can i do this thanks