I have columns with
) year, ascending
) month, ascending
) day, ascending
) investment, variable
) income, variable
) expense, variable
and I want to calculate the return on investment column, which I define as
cumulative investment averaged over a year back in time / ( cumulative income over a year back in time - cumulative expense over a year back in time)
How do I define such a column?