Clay team - in this table, we would like to differentiate new hire vs....

Clay team - in this table, we would like to differentiate new hire vs. promotions in a company, however, it told us “the changes would cause an infinite loop … try again”. Any chances our formula is wrong or is there another way to do it? thanks in advance