AnsweredAssumed Answered

Carry Over If Statement

Question asked by dg3321 on Jul 17, 2012
Latest reply on Aug 15, 2012 by philmodjunk


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.