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 strongm 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
Yaffle: Thanks for the feedback. Yes, your solution works but sometimes, but not always, users want to see the row-level detail in addition to the overall calculation.<br><br>This is the recommended solution I received from a Business Objects contact:<br><br>1. Create a SUM... -
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...
