Column-----> A------- B-------C-------D---------E(adsbygoogle = window.adsbygoogle || []).push({});

Beds------> 21.0-- 181125 - 0.0001 - 95600 -- 11.08405797

Balls------> 180 --- 39255 -- 0.0046 - 17715 -- 81.23041651

Results----> 201---220380 - 0.0009 - 113315 - 103.3501906

sum sum X/Y sum CxD

I have the above problem on a program I am writing and need the mathmatical solution to get the right results row. This program is used in the SAP BW Warehouse software. The program deliveries the above result. It calculates the the result row by the formula below the results row. What I want to get to is for column E to sum to 92.31447 and not 103.350. The program for programmable reasons cannot sum the two rows so I need to derive a formula with the figures above to get to the desired result of 92.31447

Any help will be appreciated. I am just about off my head!!

Cannot get the formating correcthence the ---. Basically I have 5 columns A-E.

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Weighted Averages

**Physics Forums | Science Articles, Homework Help, Discussion**