This week in Dynamics 365 CRM Support, we’ll look at how to create a calculated field on a form in Microsoft Dynamics 365 for Sales CRM.

In this example, I’m going to add a field called “anniversary” to my accounts. This field will display the anniversary of our relationship with each company.

You can modify the instructions below to create other calculated fields in other entities.

See below for video and instructions:

 

 

Create a calculated field

1.) Go to Settings > Administration > Customization > Customize the System.

2.) Select Entities > Accounts > Fields, then click New to create a calculated field:

Customize Entities Accounts Fields Microsoft Dynamics 365 for Sales CRM

3.) Enter a Display Name and Data Type, then set the Field Type to Calculated:

Create a Calculated Field Microsoft Dynamics 365 for Sales CRM

You can also enable field security, enable auditing, add a description, etc. But for this example, we’ll skip those extra steps.

4.) Click Edit to set up the field function, then set the Action to ADDMONTHS(12,createdon) and click the ✔ button:

Set Anniversary Calculated Field Microsoft Dynamics 365 for Sales CRM

5.) Click Save and Close.

6.) Click Publish all Customizations:

Publish All Customizations Microsoft Dynamics 365 for Sales CRM

 

Add a calculated field to a form

1.) Go to the record you want to add a calculated field to and click Form:

Add Form to Account Record Microsoft Dynamics 365 for Sales CRM

2.) Find the field you want to add in the Field Explorer, then drag and drop it into the form where you want it to appear:

Add Calculated Field to Form Microsoft Dynamics 365 for Sales CRM

3.) Click Save and then Publish, then close the form window.

4.) Click F5 to refresh the record sceen.

You should now see your calculated field on the record:

Calculated Field Added to Account Form Microsoft Dynamics 365 for Sales CRM

 

I hope this video has been helpful. Join us next week for more CRM Support tips.

Click here to learn more about OnTrack Support and how we can help you get the most out of Dynamics 365 for Sales CRM.

 

 

Was this video helpful? Enjoyable? Do you have feedback or additional questions? Let us know in the comments, or contact us directly. We’re here to help!