• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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+

Deleted User
New Member Send Private Message
Posts: 0
New 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 Send Private Message
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?
Deleted User
New Member Send Private Message
Posts: 0
New 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 Send Private Message
Posts: 47
Veteran Member
9/14/2011 7:14 PM
Thank you again, mine is working well now. Resolved.