“Calculated Field” is a new feature introduced in CRM 2015 which can be used to store calculated values. The key benefit is, this can be setup from CRM UI without any code.

Let’s have a look at how to setup this field type and the scope of this field type in implementations.

Here the requirement is to create a field to calculate the number of days since the Account record is last modified and to display the value on ‘Account’ form as well as on ‘Active Accounts’ view.

Steps to create the Calculated field:

  • Setting up ‘Calculated Field’ is just like any other field in an entity and can be done from Settings>Customizations>Solutions ~ Components> Entities> {Entity} > Fields >New


  • Enter field details:


  • Click on ‘Edit’ to create the field and to open a new window to configure the field:


  • Once the field is created, it will open the window to configure the field 
    1. Add any Condition if need to limit the calculation based on any conditions (eg: if Account status == Active) – I haven’t added any condition in my case
    2. Add the Action – which is the function to do the calculation. There are also many built in methods available to choose from:


  • I have set up the Action like this: To get the difference between last modified date and current date



  • Finally, the configuration window would look like


  • Added the field on to the Account form:


  • When I opened the form, it shows the number of days since the Account’s last modified date

Before updating the Account record:


After updating the Account record:


  • I have added this field to the ‘Active Accounts’ view as well



Here I just demonstrated a very simple usage of the ‘Calculated field’ and can be used for getting the real business benefits to improve the CRM solution!


PS: Calculated field is created as a ‘Computed’ field in the DB back-end and there would be a function associated with the field.


Hope this helps!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s