# Calculate 1 year return based on 12 monthly returns

on
I currently use Excel to get the 1 year return by using the product function by taking all the monthly returns for a mutual fund, adding 1 to each of them and multiplying all the values together like =(A1*A2*A3.....*A12 )-1

I have looked all over in Crystal for this function and I have had no luck, is there a way to do this?
Comment
Watch Question

Do more with

EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Are you dealing with 1 record with 12 values or 1 record per month

1 record with 12 values
(1+{JanReturn}) * (1+{FebReturn}) * (1+{MarReturn}) * (1+{AprReturn}) * (1+{MayReturn}) * (1+{JunReturn}) * (1+{JulReturn}) * (1+{AugReturn}) * (1+{SepReturn}) * (1+{OctReturn}) * (1+{NovReturn}) * (1+{DecReturn})

If you have 1 record per month
Group by the stock or security
WhilePrintingRecords;
Global NumberVar RateofReturn;
RateofReturn := 1;
""

WhilePrintingRecords;
Global NumberVar RateofReturn;
RateofReturn := 1;
""

In the details add a formula
WhilePrintingRecords;
Global NumberVar RateofReturn;
RateofReturn := RateofReturn * (1 + {ReturnRateField});
""

In the group footer add a formula to display the retunr
WhilePrintingRecords;
Global NumberVar RateofReturn;
RateofReturn

mlmcc

Commented:
That works GREAT!!!!!!!

Do more with