web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Calculated fields not working with related entities

(0) ShareShare
ReportReport
Posted on by 110

Hi all,

I have created a couple of calculated fields on the contact entity. The purpose of these fields is to look at the parent company record and take a single value from a field.

However, the fields won't pull through. I understand that you cannot use the standard parent company field, so I created a custom lookup field/relationship.

I have double checked and can confirm that all of the relevant fields have values, but none of my fields have calculated. 

What am I missing?

calc.PNG

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: Calculated fields not working with related entities

    you have to create child entities to calculate fields with related entities, and then create a custom relationship of all the fields.

  • Suggested answer
    CMilton Profile Picture
    110 on at
    RE: Calculated fields not working with related entities

    I managed to get the field working by wrapping the statement in brackets. Strangely, when i reopen the calculated field the brackets are gone, but the field continues to work.

    Not sure if this is a bug or not, this instance is on-premise version 8.2.1.176.

  • Suggested answer
    sandeepstw Profile Picture
    4,601 on at
    RE: Calculated fields not working with related entities

    Hi,

    Check this article -

    community.dynamics.com/.../251197

  • Suggested answer
    gdas Profile Picture
    50,091 Moderator on at
    RE: Calculated fields not working with related entities

    Not sure what you are missing here , but this could be due to relationship reference

    Below article will be guide you to create sample one , so please do a test first with sample  one.

    technet.microsoft.com/.../dn832103.aspx

    www.inogic.com/.../accessing-related-entities-fields-in-calculated-fields-formulas-in-microsoft-dynamics-crm-2015-online-update-1

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Christoph Pock Profile Picture

Christoph Pock 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans