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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Calculated Field : The...
Microsoft Dynamics CRM (Archived)

Calculated Field : The formula contains an invalid reference

(0) ShareShare
ReportReport
Posted on by Itz_Me_Ram 155

I was trying to concatenate contact address fields. But for some reason, it gives the following error :

The formula contains an invalid reference: address1_line1.
Concat function doesn't even show address1_line1 field.
4667.1.JPG
Please let me know the solution.
Thanks..

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,628 on at

    Hi,

    I tested in my environment, I cant reproduce the problem.

    You can try to delete the field and create the calculated field again.

    4628.2.PNG

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi,

    I replicate same formula in my trial instance with the screenshot you provided but I could not replicate the issue .

    2019_2D00_03_2D00_12_5F00_11_2D00_07_2D00_46.jpg

    Then I tried to modified the field name and  put some invalid field name like below and got the same error. 

    2019_2D00_03_2D00_12_5F00_11_2D00_07_2D00_46.jpg

    In summary the error you will get when there is no field name in the system which you referred in calculated field .Recommended way is to select the fields  instead of type yourself to avoid this kind of issue. Try to recreate once the formula again , make sure you select fields from auto populated list , hopefully it will works.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans