How does the progress calculation Sum of all check-ins divided by sum of all targets in control KPI work?

Category: KPIs

Profit.co has 4 progress calculation methods for the control KPI key result type.

Why this feature?

By considering both successful and unsuccessful check-ins in the sum for progress calculation, a comprehensive overview of project advancement is provided, enabling better evaluation and identification of areas for improvement.

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 score will be calculated with QTD value. 

The Progress Calculation (At most):

The progress calculation formula is,

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

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

First check-in is  $800   

Second check-in is  $750 

Sum of First check-in and second check-in =  $1550

Target sum  =  $2000 (i.e, Sum of target value(1000 + 1000 = 2000)) 

Note: You have to consider all the check-in values for the calculation. Here for example we have considered only two check-in values (First & Second check-ins), hence the target sum should be calculated as (1000 + 1000 = 2000)

Difference = Target Sum - Sum of First check-in and second check-in

Therefore, Difference  = 2000 -1550  = 450

Progress = 100+ (450/2000) * 100

                = 100+22.5 

                = 122.5%

Progress = 122.5%

QTD =  $1550

The Progress Calculation (At least):

The progress calculation formula is,

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

For example, We have a  Key result to "Gather at least 100 people for a live music concert."

First check-in - 25 

Second check-in - 30

Sum of First check-in and second check-in = 55

Target sum = 200  (i.e, Sum of target value(100 + 100 = 200)

Note: As we have considered only two check-in values, the target sum should be calculated as (100 + 100 = 200)

Difference = Target Sum - Sum of First check-in and second check-in

Therefore, Difference = 200-55  = 145

Progress = 100 - (145/200) * 100

               = 100 - 72.5 

               = 28 %

Progress = 28 %

QTD = 55

Related answer post

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

Related Questions