• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Are You Taking Advantage of Calculated Fields?

May 13, 2017   Microsoft Dynamics CRM
CRM Blog Are You Taking Advantage of Calculated Fields?

I’ve been using calculated fields more and more while working with clients lately. They seem to be an answer to many scenarios that previously required jscript or plugins. While plugins were reliable solutions to calculate forms, they required hours of development versus a couple of minutes to create a calculated field.

Here are a few notes that I have put together when working with calculated fields. these notes have been very useful as I plan out customizations for our clients. Here is another article we published when calculated fields first became available.

Here is the Good

  • You can create a calculated field on a child entity that relates to a parent entity
  • You can use calculated fields to concatenate on a text field
  • You can use date functions to calculate Difference between date fields as well as calculate days into the future
  • Whole Number, Decimal and Currency fields use common excel like functions
  • OptionSets and Two Option fields are supported
  • Calculated fields can use branching logic so fields can have different calculations based on different fields on the record

Here is the Bad

Fields

  • You cannot use fields on a related entity in the calculation.
  • You cannot change existing fields to calculated fields – for example, if you want the Estimated Revenue field on an opportunity to have a different calculation, you cannot update the built in calculation.
  • Calculated fields are not available for floating number or Lookup type fields.

Views

  • Calculated fields can be placed on a view – but you cannot export that view to Excel if you have more than ten calculated fields.
  • Calculated fields may not always be sortable on a view if the calculation references another calculated field or a field on a parent record.

And Here are the Available Functions

Function Syntax Description Return type
ADDDAYS (whole number, date and time) Returns a new date and time that is equal to the given date and time, plus the specified number of days. Date and Time
ADDHOURS (whole number, date and time) Returns a new date and time that is equal to the given date and time, plus the specified number of hours. Date and Time
ADDMONTHS (whole number, date and time) Returns a new date and time that is equal to the given date and time, plus the specified number of months. Date and Time
ADDWEEKS (whole number, date and time) Returns a new date and time that is equal to the given date and time, plus the specified number of weeks. Date and Time
ADDYEARS (whole number, date and time) Returns a new date and time that is equal to the given date and time, plus the specified number of years. Date and Time
SUBTRACTDAYS (whole number, date and time) Returns a new date and time that is equal to the given date and time, minus the specified number of days. Date and Time
SUBTRACTHOURS (whole number, date and time) Returns a new date and time that is equal to the given date and time, minus the specified number of hours. Date and Time
SUBTRACTMONTHS (whole number, date and time) Returns a new date and time that is equal to the given date and time, minus the specified number of months. Date and Time
SUBTRACTWEEKS (whole number, date and time) Returns a new date and time that is equal to the given date and time, minus the specified number of weeks. Date and Time
SUBTRACTYEARS (whole number, date and time) Returns a new date and time that is equal to the given date and time, minus the specified number of years. Date and Time
DIFFINDAYS (date and time, date and time) Returns the difference in days between two Date and Time fields. If both dates and times fall on the same day, the difference is zero. Whole Number
DIFFINHOURS (date and time, date and time) Returns the difference in hours between two Date and Time fields. Whole Number
DIFFINMINUTES (date and time, date and time) Returns the difference in minutes between two Date and Time fields. Whole Number
DIFFINMONTHS (date and time, date and time) Returns the difference in months between two Date and Time fields. If both dates and times fall on the same month, the difference is zero. Whole Number
DIFFINWEEKS (date and time, date and time) Returns the difference in weeks between two Date and Time fields. If both dates and times fall on the same week, the difference is zero. Whole Number
DIFFINYEARS (date and time, date and time) Returns the difference in years between two Date and Time fields. If both dates and times fall on the same year, the difference is zero. Whole Number
CONCAT (single line of text, single line of text, … single line of text) Returns a string that is the result of concatenating two or more strings. String
TRIMLEFT (single line of text, whole number) Returns a string that contains a copy of a specified string without the first N-characters. String
TRIMRIGHT (single line of text, whole number) Returns a string that contains a copy of a specified string without the last N-characters. String

Now it’s Your Turn

enCloud9 has one of the most experienced Microsoft Dynamics CRM teams in the US. From pre-sales to project management, and user support, we respond quickly with our expertise to answer your questions. We are a Silver Microsoft Cloud CRM partner based in Omaha Nebraska and from our heartland roots we deliver best of class service to customers throughout the United States and Canada.

Our history dates back to 2009 – During the Dynamics CRM 4.0 days! – but our experience dates back even longer. Our consultants have been advising companies for almost thirty years to give them the tools to achieve their goals. Our experience leads to your success. We use our unique approach in helping small and medium-sized businesses lower their costs and boost productivity through Microsoft’s powerful range of cloud-based software.

We can be contacted at our webform or call us today at 1-844-264-0729

To read more about the benefits of a CRM solution, read our recent blog entry “Can Your Business Benefit From a CRM?”

Let’s block ads! (Why?)

CRM Software Blog | Dynamics 365

Advantage, Calculated, Fields, Taking
  • Recent Posts

    • Accelerate Your Data Strategies and Investments to Stay Competitive in the Banking Sector
    • SQL Server Security – Fixed server and database roles
    • Teradata Named a Leader in Cloud Data Warehouse Evaluation by Independent Research Firm
    • Derivative of a norm
    • TODAY’S OPEN THREAD
  • Categories

  • Archives

    • April 2021
    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited