AnsweredAssumed Answered

Cashflow carried forward calculation

Question asked by bwoods on Nov 2, 2015
Latest reply on Nov 2, 2015 by bwoods

I am trying to create a cashflow system for projects which all have varying time frames.  Each project will have its own project ID and a cashflow table, the cash flow table has  a record for each month of the project with the following fields:

1)  Expenditure

2) Income

3) Profit for month (calculation of income - expenditure)

4) Balance (carried forward from previous month with profit or loss added)

 

I would like  this to work without having to run a script to recalculate the table if changes are made.  I cannot see a way to do this without a script though.  

 

Does anyone have any suggestions?

 

Thanks in advance

 

Brenton

Outcomes