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

unable to exclude defaulted "SCREEN_ENTRY_VALUE" using Fast Formula

Received Response
54
Views
1
Comments
edited Apr 10, 2017 7:28AM in HCM Integrations 1 comment

Content

Hello Everyone,

I am trying to pull out the element entries related to a person record. Now I have a requirement to cut out the element entries details where "SCREEN_ENTRY_VALUE" value is null. I have written the below FF Criteria to do so but it is not returning expected result:

 

DEFAULT FOR "ELEMENT_ENTRY_BASE_VALUE_NAME" IS ' '
DEFAULT FOR "ELEMENT_ENTRY_RGE_VALUE" IS 'NA'

INPUTS ARE "ELEMENT_ENTRY_RGE_BASE_VALUE_NAME" (TEXT), "ELEMENT_ENTRY_RGE_VALUE" (TEXT)

IF  (TRIM("ELEMENT_ENTRY_RGE_BASE_VALUE_NAME") = 'Amount Net') THEN (
    INCLUDE = 'FALSE'
    RETURN INCLUDE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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