Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Weighted Average Formula not working ?

Hi all,

 

When I make my calculation in Excel for the weighted average, I get a different % for the risk assessment in BI.

It should be 92,3% and I am getting 114,1%. Which is already strange because it should not be above 100%. 


What am I doing wrong?  I checked my base data and I see nothing strange. And what it even more strange, is that all other categories are correct, only the risk assessment category is wrong. 

 

 

 

 

 

  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    please try

    =
DIVIDE (
    SUMX (
        'databestand',
        'databestand'[Score in %] * 'databestand'[Aantal dossiers getoetst]
    ),
    SUM ( 'databestand'[Aantal dossiers getoetst] )
)

3 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous 

    please try

    =
DIVIDE (
    SUMX (
        'databestand',
        'databestand'[Score in %] * 'databestand'[Aantal dossiers getoetst]
    ),
    SUM ( 'databestand'[Aantal dossiers getoetst] )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      My godddddddddddd... you know how much time I have wasted on this🤣🤣🤣

       

      GOD BLESSS YOUUUUUUUUUUUU....... 

       

      I you were here in my neighbourhood I would have brought you a box of chocolates..... Thank you soooooooo much. 

       

      I knew something had to be wrong with the formula, but we used the quick measure for BI and thought that it had setup the correct formula. 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    weightage avg = 

    SUMX(category_values,table[score 1%] * table[antal]) / [Total antal]