Skip to main content

How JET's Employees Screen Calculates Its Data

Learn how Indigo's Job Evaluation Tool calculates remuneration data in its Employees screen, presenting you reliable gender pay comparisons, average remuneration, and variance formulas for accurate reporting and EU Pay Transparency compliance.

Written by Matthew Calleja

Table of Contents

Overview

If you’ve looked at the Employees screen in the Job Evaluation Tool (JET), you’ll have seen how it highlights differences between individual remuneration and category averages. 💰 It’s designed to provide clear, actionable insight that supports your organisation’s responsibilities under the EU Pay Transparency Directive.

Naturally, the next questions to ask are: “How exactly are these figures calculated, and are they reliable?”

This article answers that in full. It breaks down the formulas behind the key fields in the grid, so you can understand, explain, and confidently rely on the data; whether you’re reviewing pay internally or preparing for audit.

JET's Focus in the Employees Screen

The Employees screen helps you quickly see how each employee’s total remuneration compares with the average for their occupation category (based on occupation evaluation scores), split by gender. You can access it by going to Indigo > HR > Job Evaluation Tool > Employees.


​The key outputs are:

  • Average remuneration per gender (within an occupation category)

    • Grid columns: Avg. Remuneration (all genders) / (male) / (female) / (other)

  • Difference in € (per employee vs their gender average)

  • Difference in % (per employee vs their gender average)

📜 Note: the grid displays certain columns by default, while hiding others. You can customise your view of the grid using the column selector.

These figures are calculated using consistent, standardised rules across all employees within the selected year. This consistency ensures reliability, as JET applies the same logic across:

  • All payroll setups

  • All employment types (full-time, part-time, etc.)

  • All employment events (hires, terminations, changes)

Because the same rules are applied throughout, the results are:

  • Comparable across employees and categories

  • Transparent in how they’re derived

  • Defensible for internal reviews and external audits
    ​

💡 Spruce up your screen with improved accuracy! Learn how to:

Formulae

For Gender-specific average remuneration

For each occupation category and gender group (Male, Female, Other), JET calculates an average remuneration. In other words, JET groups employees by category and gender, then calculates the average pay within each group.

Gender-Specific Average Remuneration: The average remuneration for a given gender (male, female, or other) in an occupation category is calculated by dividing the sum of total remuneration for all employees of that gender by the number of employees in that category.

For Difference in € (per employee)

Once the average is established, JET compares each employee’s remuneration against it.

Difference in € (Gender): The difference in euro for an employee is calculated by subtracting the average remuneration of the chosen gender in the occupation category from the employee’s total remuneration.

The answer to this shows:

  • A positive value → employee earns above the category average.

  • A negative value → employee earns below the category average.

For Difference in % (per employee)

To make comparisons clearer across different pay levels, JET also expresses the difference as a percentage.

Difference % (Gender): The difference percentage per gender is calculated by taking the employee’s total remuneration minus the average remuneration for that gender in the category, then dividing by the average remuneration of that gender, resulting in a percentage variance from the average.

What this shows:

  • 0% → exactly at the average.

  • Positive % → above average.

  • Negative % → below average.

Did this answer your question?