Logistics underpaid gratuity
UAE gratuity: none below 1 year of service; 21 days of basic salary (BasicAtExit / 30) for each of the first 5 years, 30 days for each year after, capped at 24 months of basic; years = (LastWorkingDay - HireDate + 1) / 365. For Mizan Logistics exits whose settlement was paid (SettlementPaidOn) before 1 July 2025, what is the total shortfall of GratuityPaid against the law (ignore any overpayment), in USD?
- Expected
- One amount in USD, 2 decimals · KPI card
- Tables
-
FactExit, DimEmployee · columns