KPI Deliverable for project Report issue

Hi,

Projeqtor Version V9.3.4

It's appears that the bottom summary in the report is not accurate, it is not showing the correct value.

 

Can you have a look at this issue, or maybe i'm just missing something, 

Regards 

Karl

Hi

thank you for your answer, here are my comments

We understand well how the calculation is made, our question is more about the results that are displayed seem inconsistent with what we find in the database

 

So referring to the data in report/kpiDeliverable.php, we understand that the values of the tables kpiHistory and kpiValue are used.

However, these values do not seem to be in harmony

kpivalue

 

According to our calculations, the value in the database is good è 73% advancement

Our Internal Dashboard that calculates the same thing by compiling the table of deliverables :

 

kpihistory
gives us no results

 

If we look at another project: 4828
Values are incomplete and incorrect  :

 

The value of our dashboard and the kpiValue table are good « 96% » :

 

kpiHistory

 

So it seems that the assembly of the summary table by weeks in the report does not show the right values, although they are compiled correctly in the database.


 

Thanks for your answer. Unfortunately, we are not averaging while doing our calculation. We have tested on a fresh install v 9.4.3. with 2 deliverables of same weight (high) : first one at 100% (completed/accepted without reservations) and the other one not done (0%).

Our understanding of the formulas is :
SUM( status(%) * weight) / SUM(weight)
So, with our example (high weight = 1 – by default) :

((100% *1) + (0% * 1)) / (1 +1) = 50% KPI
1 / 2 = 50% KPI

 

KPI does not seem to reflect our previous result (50%) in the table (0%) neither is the graph (near 65%)

 

Our question is the following:
Is our understanding of the formula and the report values wrong?