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!