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

    GetNthRecord Issues

    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