How can I combine more than one deduction on my check stub?
Description

Cause

Resolution

You can use a formula to combine deductions on your check stub.

Use the following formulas as an example for combining deductions for Current check and YTD amounts.

Note: For the purpose of the example formulas below, the deduction IDs we are combining are HEALTH and HEALTH2.

Current Check Deductions:

Lookup(Amount [PR Check Deduct],Employee[PR Check],Period End Date[PR Check],Check Sequence[PR Check],"HEALTH") + Lookup(Amount[PR Check Deduct],Employee[PR Check],Period End Date[PR Check],Check Sequence[PR Check],"HEALTH2")

YTD Deduction Amount:

Lookup(YTD Deduction[PR Employee Deduct],Employee[PR Check],"HEALTH") + Lookup(YTD Deduction[PR Employee Deduct],Employee[PR Check],"HEALTH2")

Steps to duplicate
Related Solutions

What is the LOOKUP format for payroll processing formulas?