How to calculate Sum like Excel
am new user for fm11pro and learing little bit around linda essential training. after my learning curve i try to create my own simple expediture data base. but i dont know how to create the following equation like excel sheet. please help for growing eager developer.
IN Excel :
|28-May-11||Kraft Slice Chease||24.00||-24.00|
|28-May-11||Wheat Bread Pack||10.00||-34.00|
That is : E2 = (E1-C2)+D2
Problem is in fm11 i dont know how to call previous field and record and how to implement this.