A user in the same system wishes to maintain the weighted average score of a student for the entire year. The user has devised a formula and wishes the system to maintain the score without any extra input from her side.

The scenario can be achieved using Calculated fields in Microsoft Dynamics CRM 2016. In the earlier versions of Dynamics CRM, the user had to write a custom code in JavaScript, or a plugin, to carry out this logic. However, in this edition of Microsoft Dynamics CRM 2016, we can achieve this functionality without having to write any custom code. The following are the steps for doing the same:

1. The first step is to create individual custom fields for assignments, midyear score, final year score, and weighted average score:

2. Next, the user needs to create a weighted average field for the total score. The field type should be Calculated:

3. Now save the field. A popup should come up. As we do not need any prevalidated conditions for the scenario, we can leave the condition area blank and just start filling the values in the ACTION tab:

4. Enter the following formula:

Weighted Score = new_internalassignments * .2 + new_midyearscore * .3 + new_finalyearscore * .5

5. Save and close the field:

6. After the Weighted Score field has been created, it can then be used in the student form, or wherever the user wants this field to appear.

Before going further, it is a good idea to discuss the various entity forms available in Dynamics CRM.