Skip to main content
DD-HRM-002 Mizan Manufacturing and Logistics: Two Payrolls, One Ledger — HR & Payroll Analytics Get the data →
DD-HRM-002-Q040 Very Hard Time series

Leave liability at 31 December 2025

Annual leave owed = OpeningLeaveBalance + 30/365.25 days for each calendar day from 1 January 2023 (or the HireDate if later) to 31 December 2025 inclusive - the "Annual leave" days taken up to and including 31 December 2025 (a leave running past that date counts only its days up to it). Value it at the ContractAmount of their 202512 "Basic" line / 30 per day. What is the liability for the employees on the payroll on 31 December 2025, in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactLeave, FactPayroll, DimEmployee · columns
  • FactLeave
  • FactPayroll
  • DimEmployee
  • OpeningLeaveBalance
  • StartDate
  • CalendarDays
  • ContractAmount
  • HireDate

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us