When watching the video for adding the "Should be in Active subset?", Defined in Active Subset" and "Load to Active subset" was written correctly
In the "Should be in active", it compares start and leave date to the current period, using start date < current period.
Shouldn't this be < = current period? Shouldn't the person who starts in the same month as the current period be included
The other line I question is the "Load to Active subset". Which says S/B active <> Defined in Active Subset?
When I look at employees who start after the current period (S/B in Active is false), but the defined in Active is marked true, shouldn't the Load to Active subset also be marked false because they haven't started yet, so the "Load to Active subset" formula be something like:
If S/B Active and Defined in Active? then false else if S/B in Active and not Defined in Active then true else false
If the Load to Active subset formula in the video is correct, then I question why is active marked true, if the employee hasn't started?
