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:
- Lets go ahead and create the three fields.
- Item Cost
- Assembly Cost
- Optional Accessory
2. Next, lets add the Calculated Field. Make sure you set the Field Type as “Calculated”.
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.
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 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!