Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Report on Payroll Result Lines on Worker Business Object

Example: Report on Payroll Result Lines on Worker Business Object

This example suggests 1 way you can use calculated fields to sum a specific payroll result line.
You want a report that sums regular wages for completed pay periods. You need to create 2 calculated fields:
  • 1 to identify result lines belonging to the pay component for regular wages (Example: Hourly pay).
  • 1 to sum the result lines where the pay component is hourly pay.
  1. Access the
    Create Calculated Field
     task.
  2. For the first calculated field, enter:
    Option Description
    Field Name
    PC on Payroll Result Line is Hourly Pay
    Business Object
    Payroll Result Line
    Function
    True/False Condition
  3. On the
    Calculation
     tab for the
    PC on Payroll Result Line is Hourly Pay
     calculated field, enter:
    Option Description
    And/Or
    And
    Field
    Earning
    Operator
    In the selection list
    Comparison Type
    Value specified in this filter
    Comparison Value
    Hourly Pay
  4. Create a second calculated field with these values:
    Option Description
    Field Name
    Sum of Regular Wages for Worker
    Business Object
    Worker
    Function
    Sum Related Instances
  5. On the
    Calculation
     tab for the
    Sum of Regular Wages for Worker
     calculated field, enter:
    Option Description
    Related Field
    Payroll Result Lines within Date Range (Completed)
    Sum Instances where condition is true
    PC on Payroll Result Line is Hourly Pay
    Field to Sum
    Result Line Amount
  6. Access the
    Create Custom Report
     task and enter these values:
    Option Description
    Report Name
    Hourly Pay for Completed Periods
    Report Type
    Advanced
    Data Source
    Select a data source based on the
    Worker
     business object. Example:
    All Active and Terminated Workers
    .
  7. On the
    Columns
     tab, add the
    Sum of Regular Wages for Worker
     calculated field to the report.
The
Sum of Regular Wages for Worker
 field on the custom report gives you the sum of the regular wage earnings for workers within the specified dates.