SFDC Contact field values are null but show value on a report | Community
Skip to main content
Devraj_Grewal
Level 10
January 22, 2018
Question

SFDC Contact field values are null but show value on a report

  • January 22, 2018
  • 1 reply
  • 2374 views

SFDC question here. I pulled a Contacts & Accounts report and brought in the account phone number and the contact phone number in the report. What's strange is that on the report, some contacts who do not have a phone number on the contact object have a contact phone number listed on the report that is the same as the account phone. Is it possible that since there is no value for the contact phone that it is somehow inheriting the value from the account phone?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Veronica_Holme4
Level 9
January 22, 2018

Honestly, if it were doing that it'd need to be a workflow or formula of some kind, and you would see the result in the Contact record just by looking in the page layout as well. So if you can't see that, it's unlikely. Reports are just a reflection of the data in the field. It's more likely you have multiple "phone" fields and you've accidentally go one rather than the other showing in your report.

Salesforce reports are tricky to troubleshoot without actually seeing the report though.