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

1843 0
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
11 - Venus

Hi @Dale
Would you be able to share how you have your data laid out or explain how you are running the payroll settlement?

4 - Data Explorer

Sure - how would the best way to do that be?

11 - Venus

You can paste screenshots directly in the reply window here.

4 - Data Explorer

100% honest here - I dont know how to do that

4 - Data Explorer

My payroll is based on loads Delivered - my drivers are paid a percentage of the gross of each load then the monthly insurance cost is deducted weekly from the drivers settlement.

example - load pays \$1000, Driver gets paid 80% or \$800 the the weekly insurance is deducted from the sum of the loads for the week so lets say the driver portion is \$1500 then we would deduct say \$200 from that for the net to the driver to be \$1300

11 - Venus

Not a problem.

You have field that calculates the load pay (1000) and you just need a formula to deduct a set percent. Is it always 20% for everyone? or do you have a field that sets the deduction amount per person?

If the later is set up as

then this formula will deduct the percentage from the sub total

``````{Total Load}-{Total Load}*{Deduction amount}
``````
4 - Data Explorer

I have the same basic formula as you have there, im needing a formula for how to make a deduction once a week instead out of every load

11 - Venus

Ok that is good.

I am a little confused about how you are introducing time into the process.

Do you have a table of payroll that is linked to people and the workload? In that table are you rolling up the total loads over the week, and then deducting the insurance?

5 - Automation Enthusiast

You can make the formula dependent upon a day of the week. Datetime_Format provides a way to get the ‘day of the week’.

So you could do this with something like `IF(DATETIME_FORMAT(TODAY(), 'dddd') = 'Thursday',{Total Load}-{Total Load}*{Deduction amount})`

This should check if today is ‘Thursday’ and then provide the ‘Total Pay Out’. Replace ‘Thursday’ with whatever day of the week you want, and replace the payout formula with whatever you already have. Of course, the rest of the week it will show nothing.