You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Compensation Person selection formula issue

Summary:

Hi,

I want to have only selected employees in the worksheet. I am using below FF while starting the plan. (Person selection formula)


/*=========== INPUT VALUES DEFAULTS BEGIN =====================*/

INPUTS ARE CMP_IV_PERSON_ID (number), CMP_IV_PLAN_ID (number)

/*=========== INPUT VALUES DEFAULTS ENDS======================*/


/*================ FORMULA SECTION BEGIN =======================*/

DEFAULT FOR CMP_IV_PERSON_ID IS 0 

l_selected = 'Y'


if (CMP_IV_PERSON_ID != 300000053547045 OR CMP_IV_PERSON_ID != 300000050660416) THEN 

(

l_selected = 'N'

else 

(

l_selected = 'Y'

RETURN l_selected

/*================ FORMULA SECTION END =======================*/


When i include only one CMP_IV_PERSON_ID , i can see only that employee in the worksheet under a manager, if i include CMP_IV_PERSON_ID != 300000053547045 OR CMP_IV_PERSON_ID != 300000050660416 - two person ids, then no employee is showing.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!