Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to calculate the weighted sum. However
Aging Cost Weight by Cost Weighted Aging
1 10 10/80 1*(10/80)
2 30 30/80 2*(30/80)
3 40 40/80 3*(40/80)
Total 80 1 2.375
I'd like to get the result of 2.375. However, such number doesn't show but a symble "-" Coul d somebody help me on having the weighted sum calculated? Thanks!
Sorry, I didn't notice that your cost and your weight is the same thing - just try
Sum(Aging*Cost)/Sum(total Cost)
which probably is closer to what you want to do.
HIC
What I am using to get the Weighted Aging was
Sum
(Cost)/Sum (total <CURRENT_AREA> (Cost))*AgingShould I do extra steps to get the total? Anyone knows how to do that?
Normally, weighted averages are calculated through
Sum(Weight*Cost)/Sum(Weight)
And this formula would give a correct total also. But you want to us Aging also, which perhaps complicates it. But try
Sum(Aging*Weight*Cost)/Sum(Aging*Weight)
HIC
Sorry, I didn't notice that your cost and your weight is the same thing - just try
Sum(Aging*Cost)/Sum(total Cost)
which probably is closer to what you want to do.
HIC
Oh my god!
It took me hours of time trying to figure out how to use Aggr() and you solved in such a simple way!!! Big thanks!!