Solved

# Calculate 1 year return based on 12 monthly returns

Posted on 2014-03-04
243 Views
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?
0
Question by:wilpitz

LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 39905106
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
0

Author Closing Comment

ID: 39905335
That works GREAT!!!!!!!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…