Data Type supported
- Single Line of Text
- Option Set
- Two Options
- Whole Number
- Decimal Number
- Currency
- Date and Time
Operator and Function Supported
Math Operator
à =, +, -, /, *
String Functions
àCONCAT, TRIMLEFT, TRIMRIGHT
Date Time
à ADDHOURS, ADDDAYS, ADDWEEKS, ADDMONTHS, ADDYEARS, SUBTRACTHOURS, SUBTRACTDAYS, SUBTRACTWEEKS, SUBTRACTMONTHS, SUBTRACTYEAS
Creating a new Calculated Field
For e.g. let us create a calculated field of string type that will concat first name, middle name and last name for Contact Entity.
Open Contact entity for customization à Fields à Click on New
Click on Edit to define the Calculated Field
The editor has IntelliSense
Add the field to form.
- Calculated Field are not saved in database.
- They are executed during Retrieve.
- Can be used by another calculated field.
- Calculations is done using System Account.
Discover more from Nishant Rana's Weblog
Subscribe to get the latest posts sent to your email.
Share It -
Nishant Rana's Weblog 
One thought on “Notes on Calculated Fields in CRM 2015”