- #1

- 1

- 0

Column-----> A------- B-------C-------D---------E

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.

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.

Last edited: