Carry Over If Statement
I have a monthly income/expense table where I would like to set up a formula for a 'loss carry over' field. Basically, this field only has a figure in it if the net operating income in the prior month (prior record) is negative.
Simply put, i would like to create a formula that basically says:
If 'Net Operating Income<0 in the previous record (last month), then insert that figure into the current record's 'loss carry over' field.
I could do this manually as it is very rare, but i would like to set it up automatically.