- -
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:
- = (Equal)
- + (Plus)
- (Minus)
- / (Divide)
- * (Multiply)
String Functions are :
CONCAT – Add singular lines of text together. It can be fields or actual lines of Text. If it is an actual line of text, then the text will need to be encased with double quotes.
TRIMLEFT – takes a single line of text and trims the number of characters starting from the left and working its way to the right.
TRIMRIGHT - takes a single line of text and trims the number of characters starting on the right and working its way to the left.
DateTime Functions are
ADDHOURS – Add/Subtract Hours from given Date Value.
ADDDAYS - Add/Subtract Days from given Date Value.
ADDWEEKS – Add/Subtract Weeks from given Date Value.
ADDMONTHS – Add/Subtract Months from given Date Value.
ADDYEARS – Add/Subtract Years from given Date Value.
Natalie Williams, Marketing Manager, WebSan Solutions Inc. a
Hi,
I have created a currency type calculated field in an A entity. I have B entity wherein I have a currency field. I have 1:N relationship B-->A, making B the parent entity. I am accessing the currency field in the calculated field to perform some calculation. The logic calculation in the calculated field seems to be valid as there is no error. However, there is no display on the screen.
When I try to hardcode the value of currency field,the calculated field value is displayed on the screen. Why is this so? It seems there is an internal error when a parental field is accessed in the calculated field.
Hi Jorge,
Please email [email protected], our team will be able to help you.
WebSan Team
Calculated fields allow you to perform arithmetic calculation, string operations and DateTime related operations without developer (no need to writing a single line of code) and allow you to define the value of that field. You can choose different functions that allow the data to make certain amendments while setting the value of a Calculated Fields.
Things to consider for Calculated fields:
1. Can use other Calculated Fields within the same entity.
2. They are read only.
3. They are calculated in the Database, you cannot see real time
calculations on the form.