Definition

• The MIN function calculates the minimum (lowest) value from all values within a dataset, providing a baseline reference point for performance comparisons across the group.

Purpose

• Establishes a minimum performance threshold that can be used to normalize or adjust individual performance relative to the lowest performer in the group, ensuring fair compensation structures when performance floors are needed.

How it works

• Takes all values for a specific KPI or component within the defined scope (typically team level)
• Identifies the lowest value among all participants
• Returns this minimum value to each individual in the group

Input

• Raw performance values (e.g., Sales vs Target percentages, absolute sales figures, custom KPI values)

Output

• The minimum value from the dataset (same value returned for all participants)

Scope

• Applied at the team level - minimum is calculated among all positions within the same team for the specific bonus scheme

Use Cases

• Creating performance floors where bonuses are calculated relative to the lowest performer
• Normalizing performance data by subtracting the minimum achievement from all values
• Establishing baseline metrics for teams with highly variable performance ranges
• Risk mitigation in volatile markets where absolute minimums need to be considered

Example Application