I have a validation rules as follows:
a <> related__r.b
When a is null/or empty, the validation rule fails to trigger regardless of the value in b.
I fixed the logic with the following:
OR(a <> related__r.b, AND( ISBLANK(a), NOT(ISBLANK(related__r.b), AND( ISBLANK(related__r.b), NOT(ISBLANK(a) )
Any ideas what is happening? Is this feature, a bug or a known issue?
a and b are both percentage input fields. b is in another object linked through lookup field. I've updated the code snippet to show a relationship. In my testing related__c is not null/empty.