Reusable HR metrics with LAMBDA
Wrap your turnover, absence and FTE logic into named LAMBDA functions so every report in the company uses the same definition.
Excel (advanced)01 Data integration, modelling & sample dataExpert23 min
The recording for this walkthrough is being published — the files below already contain the full model.
What you will build
- 01Write and document a named LAMBDA
- 02Test edge cases before rolling a metric out
- 03Distribute definitions as a metric library workbook
Dataset used
A metric library workbook with test cases for each function.