Skip to main content

"IF" Formula Help

  • March 4, 2018
  • 1 reply
  • 18 views
M
Forum|alt.badge.img+10

Hi all!

I am stuck with a rather simple problem…

Payroll,

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

Tnx!

:m:

    This topic has been closed for replies.

    1 reply

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • March 4, 2018

    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

    {PreviousMonthGross}-{PreviousMonthNet}+({ThisMonthHours}*{HourlyPay})

    The formula for {ThisMonthNet} would be

    MIN({ThisMonthGross},2000)

    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.

    Terms & ConditionsAccessibility statement