Contract Duration [Procurement]

KPI Contract Duration

Description Average contract duration in years

Calculation Average of (from to) datediff("day", [Contract Start Date], [Contract End Date])/365 for all dates between [Contract Start Date] and [Contract End Date]

KPI Colorgray_10_0

Variance Colororange_blue_diverging_10_0

Format Number

Positive Values 🕑 #,##0.0 yr

Negative Values (🕑 #,##0.0 yr)

Other Packs