Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Concept: Numeric Calculations for Payroll

Concept: Numeric Calculations for Payroll

You can create numeric calculations to cover several common payroll calculations.
Example: Percentage of Prorated Base Salary
You want to find a 50% of a prorated salary. You've already created:
  • Base (prorated)
     as a related calculation on earnings.
  • 0.5
     as a constant value calculation.
  1. Access the
    Create Arithmetic Calculation
     task.
  2. Complete these fields:
    1st Operand
    Operator
    2nd Operand
    Base (prorated)
    Multiply
    0.5
Example: Premium Based on Type of Shift
You want to find the shift allowance percentage based on the shift they work.
  • If they work 1st shift, they receive a premium of 6% per pay period.
  • If they work 2nd shift, they receive a premium of 10% per pay period.
  • If the shift isn't specified, they receive 5% per pay period.
You've already created 2 instance set comparison calculations, to determine the type of shift worked:
  • Worker's Shift = 1st Shift
  • Worker's Shift = 2nd Shift
  1. Access the
    Create Conditional Calculation
     task and complete these fields:
    Order
    Condition
    Result
    a
    Worker's Shift = 1st Shift
    6
    b
    Worker's Shift = 2nd Shift
    10
  2. Select
    5
     from the
    Default Response
     prompt.
Example: Dependent Age at Calendar Start Date
You want to determine the age of a dependent at the start of the calendar year.
  1. Access the
    Create Date Difference
     task.
  2. Complete these fields:
    Interval
    Start Date
    End Date
    Year
    Dependent: Date of Birth
    Date: Current Calendar Year End Date (based on Period Start Date)
Example: Reference Period for Bonus
You want to calculate the starting month for a 3-month reference period.
  1. Access the
    Create Date Increment/Decrement Calculation
     task and enter these values:
    Option
    Value
    Name
    Current Calendar Month End Date (based on Period End Date) - 3 Months
    Start Date
    Date: Current Calendar Month End Date (based on Period End Date)
    Month
    -3
  2. Access the
    Create Date Extract
     task and enter these values.
    Interval
    Date
    Month
    Current Calendar Month End Date (based on Period End Date) - 3 Months
When the period end date is 2017-07-31, the calculation returns 4.