FTE validation based on Assignment Category

Hello everyone,

We've been trying to create a validation-based rule to ensure FTE entered falls with a specific criterion based on the value of Assignment Category.
Based on the feedback on the SR for the use case we had raised, we were asked to achieve this using the following logic for this Autocomplete:

The logic should be - Create rowset for Get Assignment Work Measure - Loop through this rowset and check for FTE and value.

We wrote the below rule for testing one of the conditions in our use case and during testing we identified that this works seamlessly in most scenarios if it's a completely new hire with a new assignment. However, this rule fails if we're performing a transaction like assignment change or rehire and the assignment category selected is different from the last assignment. Any guidance to resolve this would be greatly appreciated.