The Calculation Formulas Tab

Dayforce Implementation Guide

Version
R2025.1.1
The Calculation Formulas Tab

The Calculation Formulas tab in Plan Setup > KPI Metadata is used to create calculation formulas, which drive the relationships between KPIs, zones, predecessors, and forma columns in the Plan feature.

Calculation Formulas tab settings
Setting Description
KPI Drop-down list for selecting which KPI that the calculation formula applies to. The drop-down contains all of the KPIs that are configured for your organization.
Forma Column Drop-down list for selecting which forma column the calculation formula applies to. If left blank, the formula applies to all of the forma columns for the specified KPI.
Zone Drop-down list for selecting which zone the calculation formula applies to. If left blank, the formula applies to all zones in the location.
Predecessors

Field for entering any predecessor KPIs that roll up into the calculation formula’s KPI. For example, a Non-Sales Hours KPI might contain the predecessors Non-Service Hours and Freight Hours, which add together to the total Non-Sales Hours. Enter the predecessor KPIs by their number, in brackets. For example, {1} represents KPI 1. Use arithmetical operators to denote the relationship between them:

Predecessors field with KPIs.

In the screenshot above, KPIs 44 and 24 are added together to roll up into the specified KPI. See KPI Metadata Formula Library.

Persist Values Checkbox to save the formula’s results to the database.
Daily Zone Source
Daily Location Source
Weekly Zone Source
Weekly Location Source

Drop-down lists for selecting source types. The drop-down lists contain the following options:

  • Average: Used by above store locations to provide an average KPI based on the same KPI of individual stores under it. For example, select this option to provide an average schedule efficiency score for a district. To use the Average source, the metadata set must have the Corporate checkbox selected.
  • Note: Above store averages don’t count stores with zero or no values as these missing values would skew the average.
  • Configuration: Sourced from the plan methods and plan targets.
  • Derived: Calculated by the associated formula.
  • Forecast: Sourced from the forecast table. 
  • Imported: Read-only sources, such as an imported plan or schedule.
  • Kpi Target: Sourced from a pattern defined in Plan Setup > KPI Target Pattern. See Configure KPI Target Patterns.
  • Task: Sourced from task management data in the Task Management feature. See Task Management Configuration and Task Management.
Daily Zone Formula
Daily Location Formula
Weekly Zone Formula
Weekly Location Formula
  • Fields for entering the associated formulas for sources that are configured as derived or task-based calculations. For example, if Derived is selected in the Daily Zone Source drop-down list, enter the metadata formula by which it should be calculated in the Daily Zone Formula field:
  • Example calculation for the average hourly rate.
  • In this example, the calculation to determine the average hourly rate for the KPI is the same formula in each case: {12}/({3}+40). This means that the calculation divides KPI 12, which is Earned Payroll, by the sum of KPI 3, which is Total Hours, plus 40.