"IF" Formula Help


Hi all!

I am stuck with a rather simple problem…


If you make more money in the month than you should, then transfer the overhead to the next month, example:
Salary January= 2000$

  • if jannuary is 2400$, then 2000$ in jan, and transfer 400$ to feb

Here is a simple DB link




Based on your base (so to speak), I’d create a second formula field for each month that would represent gross income. The formula would be something along the lines of


The formula for {ThisMonthNet} would be


That’s assuming you can do all your math within each record — that is, each record contains multiple months’ worth of data for an individual. If you need to perform cross-record calculations, it’s still possible… just more difficult.