Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Add Headcount Split to Payroll Journal Reports (FRA)

Example: Add Headcount Split to Payroll Journal Reports (FRA)

Illustrates how to add a headcount split by gender on the standard French payroll journal reports.
You want to include a headcount split by gender on your French payroll journal reports.
Create a custom report based on 1 of these reports:
  • FRA Payroll Journal by Company
  • FRA Payroll Journal by Establishment
Security: These domains in the System functional area:
  • Custom Field Management
  • Custom Report Management
  • Manage: All Custom Reports
  1. Access the
    Create Calculated Field
     task to create a calculated field for worker gender.
    Enter these values:
    Option Description
    Field Name
    Gender is Male
    Business Object
    Worker
    Function
    Evaluate Expression
  2. Click
    OK
     and enter these values on the
    Calculation
     tab.
    Option Description
    Field Type
    Single Instance
    Business Object
    Worker
    Default Value
    Empty Instance
  3. Add this row to the grid in the
    Calculation
     tab:
    Option Description
    Condition
    Male Gender
    Return Value If Condition is True
    Worker
  4. Click
    OK
     and
    Create Another Calculation
     to create a calculated field for the male workforce.
  5. Enter these values:
    Option Description
    Field Name
    Male Workforce
    Business Object
    Pay Component (Combined) DI
    Function
    Lookup Related Value
  6. Click
    OK
     and enter these values on the
    Calculation
     tab:
    Option Description
    Lookup Field
    Worker
    Return Value
    Gender is Male
  7. Click
    OK
     and
    Done
    .
  8. Access the
    Edit Custom Report
     task for your custom report.
    Add this row to the
    Define the Field(s) to Summarize
     section.
    Summarization Type
    Summarization Field
    Count Distinct
    Male Workforce