You are currently browsing the tag archive for the ‘Calculated Fields’ tag.

With Dynamics CRM 2015, one of the new features added is a new field type called Calculated Fields. We can see an evolution pattern here. First, we started with JScript, taking us up to CRM 2011. Later, in CRM 2013 we’ve got Business Rules to help. Now Calculated Fields is providing more specialized functionality, and enhanced features. But let’s look at the details.

I’ve created for this example two Decimal Number fields named very creatively Field Value 1 and Field Value 2, and added them to the form of a new entity. You can do this on any existing entity also.

Next I’m adding a third field of type Decimal Number. Let’s name it in the same creative fashion to Calculated Field.

Read the rest of this entry »

Calculated Fields are another of the new features added with Dynamics CRM 2015.

They are build based on entity fields and related entities through a N:1 relationship. We can use the basic math operators and string functions in defining the formula. For complex rules we can also use AND and OR.

Let’s look at a simple example of calculating a Lead Score.

We’ll start by customizing the Lead form. Add a new field named Lead Score. Set it a Whole Number, with a type of Calculated Field.

Read the rest of this entry »

MVP Reconnect

Check out my course [Video]

Dynamics 365 Customer Engagement Administration

Dynamics 365 Customer Engagement Administration

Check out my course [Video]

Configuring and Extending Dynamics 365 Customer Engagement

Configuring and Extending Dynamics 365 Customer Engagement

Check out my course [Video]

Getting Started with Dynamics 365 Customer Engagement

Reviewed Book

Implementing Microsoft Dynamics 365 for Finance and Operations

Implementing Microsoft Dynamics 365 for Finance and Operations

Reviewed Book

Microsoft Dynamics 365 Extensions Cookbook

Microsoft Dynamics 365 Extensions Cookbook

Check out my Book

Microsoft Dynamics CRM 2016 Customization - Second Edition

Microsoft Dynamics CRM 2016 Customization - Second Edition

Check out my Book

Microsoft Dynamics CRM Customization Essentials

Microsoft Dynamics CRM Customization Essentials

Check out my Book

Reviewed Book

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 609 other followers

Follow Dynamics 365 Wizardry on WordPress.com