Formulas to retrieve payroll rates from rate tables

• You can have an Other or a Regular pay type retrieve a rate from a Pay Rate Table
• You can either set up a new Pay Rate Table or use an existing table

Create a formula

Create the following formula. Modify it as needed to reflect your pay rate table. In this example, the formula looks at the Union Pay Rate table.

• Formula name: REG RATE TABLE LOOKUP
• Formula: LOOKUP(Rate [PR Pay Rate Table],"UNION",JOIN(Union ID [PR Time], Union Local [PR Time],Union Class[PR Time]))

Use this formula with a Regular Pay Type Pay ID

Select this formula in the Formula field. When entering units to this Regular Pay, you'll see the rate after processing this check.

Use this formula with an Other Pay Type Pay ID

Select the calculation method of Other Units. In the formula field, select this formula from the list. You'll see the rate after processing this check.