about calculation on the KPI

[adminkare]

hi help me pls,

I get different results from the "score" field.

The sum(score)=138 must be on the table and this is true.

but the sum(score)=100 is on the KPI and this is wrong. I think, group by "questionID"

I want to get sum(score)=138 on the KPI. How will I do?

[sunny_talwar · Accepted solution]

May be try this

Sum(Aggr(Sum(score), belediyeID, questionID))

[adminkare]

Sunny Talwar <span class="icon-status-icon icon-mvp" title="Mvp"></span> wrote:

Bu deneyin Olabilir

Sum (AGGR (Sum (skor), belediyeID, QuestionID))

Thank you sir. this was be. True answer.