Cumulative Returns in CR11

[OT2]

Hello, wondering if CR11 had a function to help me sum cumulative returns for a given period. Thanks.

 

[Turkbear]

Hi,
Not unless we know what you mean by

cumulative returns


And if you would provide basic tech stuff:
Version of Crystal
Database used and Connection method
Data model or description of data





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[OT2]

Using and ODBC into CR11 and trying to figure out a way to do a cumulative sum of a return field for a given perdio, ie:

day return%
1 .0.00%
2 -0.74%
3 -0.03%
4 -0.22%
--------------
CumRtn -0.99%

the Cumulative return formula in excel would be =(1+D1)*(1+D2)*(1+D3)*(1+D4)-1

 

[lbass]

Looks like you could just right clik on {table.return%} and insert a summary (sum).

-LB