This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- How to make a deduction automatic but only once a ...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

0
1344
13

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 10:50 AM

13 Replies 13

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 11:08 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 11:12 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 11:13 AM

You can paste screenshots directly in the reply window here.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 11:16 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 11:20 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 12:18 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 12:21 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 12:27 PM

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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 01:24 PM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 16, 2022 03:10 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 17, 2022 03:27 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 18, 2022 07:04 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 21, 2022 07:07 AM