Who's On?

	Membership:
	Latest: Mauchk
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5244

	People Online:
	Visitors: 431
	Members: 0
	Total: 431

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

pf variable problem

7 Replies

0 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

thanef

Veteran Member

Posts: 47

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

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.

KK - Infor

Veteran Member

Posts: 61

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

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

Posts: 0

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

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

Posts: 0

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

9/14/2011 7:14 PM

Thank you again, mine is working well now. Resolved.