Weighted average

[danieloberbilli]

Dear all,

I would like to get the weighted average age of 5 persons. I get along until sum(aggr(sum(PersonWeight),Age)).

The last step of the calculation would be simply to divide this result by the total number of weighted Persons - but I dont get the right Aggr with this.

Please find attached my qvw which also includes a screenshot with my calculation in Excel.

Any ideas?

Thanks a lot in advance.

Daniel

[Nicole-Smith · Accepted solution]

Is the attached what you're looking for?

[danieloberbilli]

Yes, the yellow marked value of 18.79 as average year is what I am looking to get in QV

[Nicole-Smith]

So the .qvw that I posted above gives you what you need?

[danieloberbilli]

Ahhh - sorry - I didnt see your attachment - I thought you are talking about my mine

Thanks a lot - exactly what I needed!

All the best

Daniel

[Anonymous]

Thank you that was very very helpful