Prev
Next
Forums Integration / Customization IPA/ProcessFlow

pf variable problem

 7 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
thanef
Veteran Member
Posts: 47
Veteran Member
9/14/2011 4:14 PM
    When I query the persaction table with pf and retrieve a record for a manager self service pay rate value all I get is this inside the pf variable:  000000000024900000+  I have tried trimming, rounding, and substringing.  Has anyone else accomplished transforming this value into a readable state inside pf?
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    9/14/2011 5:06 PM
      Have you tried just assigning the value to a numeric variable? That has worked for me in the past.
      David Williams
      KK - Infor
      Veteran Member
      Posts: 61
      Veteran Member
      9/14/2011 5:30 PM
        David is right.
        Or create another integer variable and assign like-
        intvar = strngvar*1
        This would convert the data type.
        thanef
        Veteran Member
        Posts: 47
        Veteran Member
        9/14/2011 5:57 PM
          Maybe I am missing something but when I assign this value to an integer variable I get zero for the result.  When I assign it to a string variable I get the large number of

          000000000024900000+

          BarbR
          Veteran Member
          Posts: 306
          Veteran Member
          9/14/2011 5:59 PM
            I use this way: substring(QPA_NEW_VALUE_1, 9, 13) + "." + substring(QPA_NEW_VALUE_1, 13, 19) assigned to a variable with type Double.
            thanef
            Veteran Member
            Posts: 47
            Veteran Member
            9/14/2011 6:19 PM
              Thank you Barb, your suggestion ended up working for me. Will your method work for a rate of $9.99 like it does for $24.99?
              BarbR
              Veteran Member
              Posts: 306
              Veteran Member
              9/14/2011 6:25 PM
                Yes. We've had backoffice and MSS Pay Change work flows running for over a year now and have not had any issues with the pay rate being interpreted incorrectly.
                thanef
                Veteran Member
                Posts: 47
                Veteran Member
                9/14/2011 7:14 PM
                  Thank you again, mine is working well now. Resolved.