AnsweredAssumed Answered

Using a different record in calculation.

Question asked by LarrySanders on Feb 19, 2011
Latest reply on Feb 23, 2011 by LarrySanders


Using a different record in calculation.


I am new at this. Please help!

In my Table, I have Row data defined by Year.

Year       Capital      Income      Return on Capital(which is calculated)

2000       196            90

2001       320            158          (Current Year Income/Previouse Year Capital)

The problem I have is this:

I need to set up a Calculation Field, Return on Capital, that uses current year's income divided by previouse year's Capital. The correct number is 0.806122. But I do not know how to do it with FM Pro 11.

Your help is greatly appreciated!