I have a Lookup relationship on Opportunity to an object named PAF. PAF has a formula field named "Result" with the this code:
IF(T_Amount__c < 385,"FAIL","PASS").
I want to show this result on the Opportunity page so I created another formula field on Opportunity named "Result" with the this code:
The problem is, if the Lookup is populated, then the Opportunity Result field shows correct data. If the Lookup field is empty then it shows "FAIL".
According to my understanding, it should display nothing?
I am able to get the expected results, using
IF. I just don't understand this behavior.