How do I calculate the Average/Sum cumulative value for the Control KPI Key Result?

Profit.co has progress calculation methods for the control KPI key results. Average of all check-ins divided by the average of targets & Sum of all check-ins divided by the sum of all targets

Why this feature?

By using this feature the key result can be progressed based on the check-in value’s Average/Sum of the target and the cumulative value of all check-ins, The calculation will be displayed in the slider bubble as QTD/ YTD value.

Average of all check-ins divided by average of targets

In this type of progression, the average of all the check-ins will be taken into consideration whether the check-in is successful or unsuccessful. The Progress will happen and the final calculation will be based on the average.

Additionally based on the target date we have QTD/YTD value in the check-in slider. If the key result is in the Quarter period, It will be mentioned as QTD. If it is an Annual period, It will be mentioned as YTD.

The Average of all the check-ins will be taken as QTD/ YTD value in the check-in slider.

Then the progress achievement score will be calculated with QTD value based on the below formula for progress calculation:

The progress Calculation formula is,

>100, 100+(diff/target*100)

For example, We have a Key result to Maintain at most $1000 marketing expenses for each week

First check-in 800

Second check-in 750

Average = 775

Here 1000 is Average of Target value(1000+ 1000)/2

Difference = 1000-775 = 225

Progress = 100+ 225/1000 = 100+22.5 =122.5%

Progress = 122.5%

QTD = $775

Sum of all check-ins divided by sum of all targets.

In this type of progression, An unsuccessful check-in will also be taken into account and the progress will be shown in the Sum. The sum of all the check-ins will be taken into consideration whether the check-in is successful or unsuccessful.

The Sum of all the check-ins will be taken as QTD/ YTD value in the check-in slider.

Progress achievement scores will be calculated with the QTD value.

The progress calculation formula

>100, 100+(diff/target*100)

For example, We have a Key result to Maintain at most $1000 marketing expenses for each week

First check-in 800

Second check-in 750

Sum = 1550

Target sum =2000

Here Target value is 2000 i.e, Sum of target value(2 x 1000)

Difference = 2000-1550 = 450

Progress = 100+ 450/2000 = 100+22.5 =122.5%

Progress = 122.5%

QTD = 1550

Related answer post:

To learn more about how Control KPI works on successful and distance from check-in work click here