Quite a few times it becomes necessary to have calculated fields on a form, for example, we may have a few fields and we want to also have the total on the form. Prior to CRM 2013, you would need to do this via JavaScript and then 2013 introduced Business Rules, which can be used to place a calculated value in a field. CRM 2015 gives us a new Field Type – Calculated Field.


Let’s take a hypothetical example, where we have a few fields and we need to display the calculated total. So we have the actual item cost, the assemble cost and optional accessory cost. We want to have a field for the total cost of the assembled item.

The process is outlined below:

  1. Lets go ahead and create the three fields.
  • Item Cost
  • Assembly Cost
  • Optional Accessory

Calculated Fields in Dynamics CRM 2015

2. Next, lets add the Calculated Field. Make sure you set the Field Type as “Calculated”.

Calculated Fields in Dynamics CRM 2015


3. Now, we need to add the calculation logic. Click on the “Edit” button.

4. This brings up the calculation business rule:

  • Enter the condition, here we are just entering one condition to check if the Item Cost is greater than 0 or not.
  • Enter the calculation logic. Select the field and then type in the operation, “+” in our case and then select the next field.

Calculated Fields in Dynamics CRM 2015

5. Once the Calculation has been setup, save the business rule, the field and add the field to the Form. Publish the customization.

6. In CRM, open the form and enter the value for Item Cost, Assembly Cost and Optional Accessory.

7. Then save the form. On Reload, the value of the Total Cost will be displayed.

Calculated Fields in Dynamics CRM 2015


Calculated fields are also closely related to Roll-up fields, wherein you can calculate across child records. We hope this answered any lingering questions! Make sure to stop by our main blog page for other great Dynamics CRM tips and tricks! Or if you are specifically interested in CRM 2015 we have created a dedicated page!

Happy CRM’ing!.

Avatar for Joe D365

Joe D365

Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.