Show 1 on last date only

Every employee gets a pay and bill unit of 1 for each week. I have this working except if someone works two different BillingRules on the same last day.

For example:

Zars, Bruno works from 8/18/25 thru 8/23/25. Because the last day he worked is 8/23/25, a PerDiem of 1 is added to the PerDiemPayUnit and PerDiemBillUnit. The problem is, that date has 2 different BillingRules on it so the PerDiemUnits are showing up on both. How can I get it so that the units only show up on one of them?

Ttest.yxzp

OUTPUT.png

Workflow

Accepted answers

KGT

You can add a RecordID and then take the max_RecordID per Name, and join on that. Your J will then be the records that get the Per Diem, whereas the L will be the rest of your records.

Also, you will want to reverse the connections on your Append as the main set should stay on the left (Target that you will append to).

Screenshot 2025-09-03 143702.png

All comments

jrgo

If it doesn't matter which one it shows, then you can use a Unique tool checking the Full Name and Time Sheet Date columns.

KGT

You can add a RecordID and then take the max_RecordID per Name, and join on that. Your J will then be the records that get the Per Diem, whereas the L will be the rest of your records.

Also, you will want to reverse the connections on your Append as the main set should stay on the left (Target that you will append to).

Screenshot 2025-09-03 143702.png

ewassell

Thank you. After much trial and error, I was able to get this to work using the record id.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703