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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
calculate product instead of sum in subtotals on report
Sorry, I forgot that you then have to subtract 1 from the final result. The equation is: ((1.0025)*(.9975)*(1.0123))-1=.0123 or 1.23% which is the return for the period. The weighting does not matter because the object is to find the total return of 1 dollar invested at the beginning of the...- bubbacake
- Post #5
- Forum: Microsoft: Access Reports
-
calculate product instead of sum in subtotals on report
The report looks like this: Australia Return Jan 01 +0.25% Feb 01 -0.25% Mar 01 +1.23% Total return for period: ?????? Australia...- bubbacake
- Post #3
- Forum: Microsoft: Access Reports
-
calculate product instead of sum in subtotals on report
I need to calculate the product of each of the items in each group on my report. Does anyone know how to do this?- bubbacake
- Thread
- Replies: 5
- Forum: Microsoft: Access Reports
