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 beca...
  • 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] )
)
tamerj1's avatar
tamerj1
Community 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.