Issue
Replicating a SOQL relationship that contains a dot notation field - will inherit the first record's information if the dot notation record field is Null.
Error Code
Replicating a SOQL relationship that contains a dot notation field - will inherit the first record's information if the dot notation record field is Null.
Resolution
Only resolutions
1. Create a salesforce formula field to pull the data down a level. - then reference that field
2. Reorder the relationship so the Null values are first
3. Apex data relationship
Additional Information
Related Links