# How to make a deduction automatic but only once a week

Topic Labels: Formulas
2270 13
cancel
Showing results for
Did you mean:
4 - Data Explorer

Im trying to figure out how to make the insurance deduction for my drivers automatic but only once a week when I run their payroll settlement.

13 Replies 13
4 - Data Explorer

Yes i do - and the roll up is what im trying to figure out how to set up

4 - Data Explorer

Ok thanks. Is it possible to do it on different days as I pay my guys at different times?

6 - Interface Innovator

Yes. You’d need to nest your if statements. Remember that an if looks like IF(A is true, Do This, Otherwise do that). Your ‘Do This’, and your ‘Otherwise do that’ can be additional IF statements. So, you build the IF needed to test for your employee and the IF needed to test the day/show a payout.
Combine those, and then each of those can be nested (added) to the 3rd position of the next IF group.

So a general structure looks like this:

``````IF( Employee A, Payout A),
IF( Employee B, Payout B),
If( Employee C, Payout C)
)
)
``````

And you’ll end up with something like this:

``````IF( {employee} = 'Joe', IF(DATETIME_FORMAT(TODAY(), 'dddd') = 'Thursday',{Total Load}-{Total Load}*{Deduction amount}), IF( {employee} = 'John', IF(DATETIME_FORMAT(TODAY(), 'dddd') = 'Friday',{Total Load}-{Total Load}*{Deduction amount}), IF( {employee} = 'Jacob', IF(DATETIME_FORMAT(TODAY(), 'dddd') = 'Wednesday',{Total Load}-{Total Load}*{Deduction amount}))))
``````
4 - Data Explorer

So my deduction is a set amount for each driver per weekly settlement - (example - bobs insurance is \$250 per week then his settlement would be say \$1000 minus the \$250 = \$750.00) the deduction is weekly out of the drivers total settlement.