Lookup Function - Pay Rate Table

Question

I'm trying to create a formula to pull rates setup on the Pay Rates table in PR. The Fields I used are "Employee" and "Job". When i use the lookup function on a custom public formula to look up a rate from my table i get an error "Too many Parameters". My formula is LOOKUP(Rate (PR Pay Rate Table),"RateTableName",Employee (PR Time),Job (PR Time)). If i modify the Pay Rate table to only one field such as Employee, i can get the formula to work. Why would the Lookup be limited if i add "Job" to the table?

Jesse Gordon · Accepted Answer

Hi Nathan, 
 You can see an example of a formula to pull a rate from a rate table by goign to Payroll, Tools, Formulas. Click Index and select PR Formulas. The formula PR Rate Table Base Rate pulls the pay rate from the CERTIFIED pay rate table which uses the Job, Certified Class, and Certified? columns. You can copy this formula and change it to meet the criteria for your specific rate table. 
 Thanks!

Nathan Jamison · Answer

Thank you Jesse, Confirmed this is the correct method. I did manage to get a response from Sage as well that you need to use the Join function to combine the parameters for this formula and table. See article Solution ID: 225924650093928; 
 Very obscure and even they had a hard time to find it. It really should be noted in the help section for the formula. 
 Pay Rate Lookup Formula Solution

Sage Construction & Real Estate

Lookup Function - Pay Rate Table

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING