2 Replies Latest reply on Oct 11, 2010 1:10 PM by tfinnegan@ccmg.com

# GetNthRecord Issues

### 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

• ###### 1. Re: GetNthRecord Issues

Well, for starters, your expression, as posted, is actually:

1 + percentage * 1 + percentage * 1 + percentage ....

You'll need some more parenthesis to get it to evaluate differently as you are multiplying by 1 instead of by ( 1 + percentage ).

• ###### 2. Re: GetNthRecord Issues

Thanks.

I kept thinking it was GetNthRecord function. I should have started with the obvious. Sorry for being stupid. Thanks.