With the recent release of Dynamics CRM 2015, Microsoft has introduced calculated fields in Dynamics CRM. Calculated fields allow you to define the value of a field using calculations operators or functions. You no longer need a developer on hand to write code, you can now create calculated fields using the CRM user interface. For example, a salesperson might want to automatically apply a discount based on an order greater than “X” dollars. The calculated field would be able to change the value using basic math operations or conditional operations.
Here is an example of a calculated field:
Order Total = ((quantity*unitprice) – ((quantity*unitprice) *Discount%/100)) + ((quantity*unitprice) – ((quantity*unitprice) *Discount%/100) *Tax%/100)
Here are some fields that are considered calculated fields:
- Weighted Revenue: Estimated revenue multiplied by probability
- Net Worth: Assets subtracted from the liabilities for a given account
- Follow Up By: Follow up on an activity by a specified number of days based on priority
The type of mathematic operations that you could use are: