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.
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:
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:
|
Daily Zone Formula Daily Location Formula Weekly Zone Formula Weekly Location Formula |
|