Restrict Transfer to HR for employees on a specific Assignment Status

Summary: We wanted to restrict the posting to HR for employees on a specific Assigment status.

The HR would like to complete all the Worksheet information and allocate compensation for all employees but would wanted to transfer to HR based on the Assignment Status.

We have created a Compensation Person Selection formula to exclude employees whose current assignment status is Leave without Pay.

The formula is not working as expected.

Code Snippet (add any code snippets that support your topic, if applicable):

/******************************************************************

FORMULA NAME : Compensation Selection Formula 

FORMULA TYPE : Compensation Person Selection 

DESCRIPTION: Assignment_Status based selection fast formula

*******************************************************************/

DEFAULT FOR HWP_EMP_ASG_STATUS IS 'X'