Fast Formula-Eligibility Profile
Summary: Fast Formula-Eligibility Profile
Content (required):Looking to create a Fast Formula that should have two conditions: LABOUR_UNION_MEMBER_FLAG='N', AND PER_ASG_HOURLY_SALARIED_CODE='’Salaried’, ’Exceptional Hourly’, 'Hourly'.
Below is the Script I have used, and getting the compilation errored out: Appreciate cloud experts assistance:
IF ( (TRIM(PER_ASG_HOURLY_SALARIED_CODE) = 'Salaried' OR TRIM(PER_ASG_HOURLY_SALARIED_CODE) = 'Exceptional Hourly' OR TRIM(PER_ASG_HOURLY_SALARIED_CODE) = 'Hourly')
AND LABOUR_UNION_MEMBER_FLAG = 'N'
)
THEN(
ELIGIBLE = 'Y'
)
RETURN ELIGIBLE
Version (include the version you are using, if applicable): 23C
Code Snippet (add any code snippets that support your topic, if applicable):