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

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

    Re: UNZONE FUNCTION

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

    Re: UNZONE FUNCTION

    ‏2012-10-08T06:15:36Z  
    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

    Re: UNZONE FUNCTION

    ‏2012-10-12T06:07:21Z  
    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.!
    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