AnsweredAssumed Answered

GetNthRecord Issues

Question asked by tfinnegan@ccmg.com on Oct 11, 2010
Latest reply on Oct 11, 2010 by tfinnegan@ccmg.com

Title

GetNthRecord Issues

Post

I'm trying to do a calculation that calls upon multiple numbers from a related table. Its not working the way I thought it would.


I have to annualize invesment returns.  example: (1+ percentage) * (1+percentage) * (1+percentage) -1

I made a field called Total Monthly Series which is just a count of all data in the related field. Then I'm using the GetNthRecord to create the calculation. The result is always wrong. Is there a better way to go about this?

Thanks for any help. Below is the calculation I'm using.

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-0)) *

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-1)) *

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-2)) *

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-3)) *

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-4)) *

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-5)) *

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-6)) *

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-7)) *

1+(GetNthRecord ( Gross Monthly Data::Monthly Return; Total Monthly Series-8)) -1

Outcomes