Forum Discussion

etrietsch's avatar
etrietsch
Frequent Visitor
7 years ago
Solved

Calculating the weighted average gives me incorrect values?

Hi,   When using the "New quick measure" button to calculate a weighed for the following example, I get a formula that doesn seem right.   Material Year Length ST 1976 400 ST 1956 ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi etrietsch,

     

    It seems like the normal measure calculate issue on total/summary level, maybe you can take a look at following link about measure total issue:

    Measure Totals, The Final Word


    Regards,

    Xiaoxin Sheng

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

it does not look too correct to me, if you post a dataset and expected results we can make a new formula

etrietsch's avatar
etrietsch
Frequent Visitor
7 years ago

Hi LivioLanzo In my question I already posted the correct version of the formula: this one works as expected. But I was wondering why the 'out of the box' formula is incorrect? Is it a bug or is do I use the wizard incorrectly? 

  • LivioLanzo's avatar
    LivioLanzo
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi etrietsch,

     

    the first formula is incorrect because it is doing a multiplication of the sum instead of a sum of the multiplication which is what the second formula is doing