Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: How to make a deduction automatic but only once a week

2074 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dale
4 - Data Explorer
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

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

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

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}))))

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.