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 check Null value of numeric EFF in item rule

edited Mar 26, 2025 8:25PM in Product Master Data Management 3 comments

Summary:
We are trying to populate the value in a (Destination) EFF based on the value in another Number type (Source) EFF. The rule works if the value in source EFF is not null. If the value in Source EFF is cleared the rule doesn't work. We tried multiple functions like CHANGED, ISNULL, CONTAINS, + (Concatenation), LENGTH (= 0) but nothing is able to capture the event when the source field is cleared.

Populating the source field from a blank EFF to a not null value triggers the rule, Switching value in Source EFF from one not null value to another also triggers the rule. ONLY when the source field having a not null value is cleared to be blank / NULL then rule doesn't work.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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