Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
trouble with complex or compound calculation
I need to create a calculation using object A and object b. Assume 10 rows of data. the basic fomula is: [(A1/SUM(A1...A10))*B1] + [(A2/SUM(A1...A10))*B2] + [(A3/SUM(A1...A10))*B3] + ....[(A10/SUM(A1...A10))*B10] = answer. Is there a way using SQL (or Business...
