| Baseline_Value__c |
Baseline Value |
Summer 2024 |
The starting value of the objective key performance indicator.
|
Number(18,4) |
|
| Category__c |
Category |
August 2024 |
The category of the objective key performance indicator.
|
Picklist:
Approval on Time
Budget Variance
Completion on Time
Customer Satisfaction
Project Margin
Reduced Timecard Errors and Time to Bill
Resource Management Margin
Skill Capacity
Time to Staff
Timecards Submitted on Time
Utilization |
|
| Current_Value__c |
Current Value |
Summer 2024 |
The current value of the objective key performance indicator.
|
Number(18,4) |
|
| Description__c |
Description |
Summer 2024 |
The description of the objective key performance indicator.
|
Text(255) |
|
| Last_Progress_Update__c |
Last Progress Update |
Winter 2025 |
For system use. Used to determine the date and time of the last progress update.
|
DateTime |
|
| Objective__c |
Objective |
Summer 2024 |
The objective that the objective key performance indicator is associated with.
Looks up to: Objective__c
|
Lookup |
|
| Previous_KPI_Progress__c |
Previous Progress |
Winter 2025 |
Calculates the previous percent completion of the objective KPI.
Formula:
IF(OR(ISNULL(Target_Value__c), ISNULL(Previous_Value__c)) , NULL , ( IF(BLANKVALUE(Baseline_Value__c, 0) = Target_Value__c, IF(Previous_Value__c < Target_Value__c, 0, 10000) , MAX( MIN( FLOOR( (Previous_Value__c - BLANKVALUE(Baseline_Value__c, 0)) / (Target_Value__c - BLANKVALUE(Baseline_Value__c, 0)) * 10000 ) , 10000) , 0) ) / 10000) )
|
Percent(18,2) |
|
| Previous_Value__c |
Previous Value |
Winter 2025 |
For system use. Used to store the previous value of the objective KPI before the latest progress update.
|
Number(18,4) |
|
| Progress__c |
Progress |
October 2024 |
Calculates the percent completion of the objective KPI.
Formula:
IF(OR(ISNULL(Target_Value__c), ISNULL(Current_Value__c)) , NULL , ( IF(BLANKVALUE(Baseline_Value__c, 0) = Target_Value__c, IF(Current_Value__c < Target_Value__c, 0, 10000) , MAX( MIN( FLOOR( (Current_Value__c - BLANKVALUE(Baseline_Value__c, 0)) / (Target_Value__c - BLANKVALUE(Baseline_Value__c, 0)) * 10000 ) , 10000) , 0) ) / 10000) )
|
Percent(18,2) |
|
| Status__c |
Status |
Winter 2025 |
The status of the objective KPI, calculated based on the objective KPI's progress.
Formula:
IF(ISBLANK(Progress__c), $Label.common_label_not_available, IF(Progress__c >= 1, $Label.common_label_completed, IF(DATEVALUE(NOW()) > Target_Date__c, $Label.objective_kpis_status_overdue, $Label.objective_kpis_status_in_progress)))
|
Text |
|
| Target_Date__c |
Target Date |
Summer 2024 |
The target date of the objective key performance indicator.
|
Date |
|
| Target_Value__c |
Target Value |
Summer 2024 |
The target value of the objective key performance indicator.
|
Number(18,4) |
|
| Unit__c |
Unit |
Summer 2024 |
The unit of measurement for the baseline, current, and target values of the objective key performance indicator.
|
Picklist:
Days
EUR
GBP
Hours
JPY
Months
Percent
Quantity
USD
Weeks |
|
