Show 1 on last date only

[ewassell]

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?

[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 · Accepted solution]

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

[ewassell]

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