By Barkley Busby
Vice President & Co-Founder, 2B Solutions
In CRM 2015, there have been some significant investments in the way power users can build insights with the data stored in their CRM system without overwriting any code. To do this, two new features have been introduced: Rollup Fields and Calculated Fields
Rollup Fields
Rollup fields are for calculations for across one to many relationships. You can think of these formulas as similar to using sum, min, max and count in Microsoft Excel. Here are some examples for how Rollup Fields can be used:
- Total Revenue: provides the total revenue for all opportunities related to an account.
- Total Open Cases: shows the sum of all cases that are open to a linked account.
- Qualified Leads: shows the total number of qualified leads that originate from a specific campaign.
Calculated Fields
Calculated Fields formulas are made up of current entity fields along with fields that are related entities through a many to one relationship. They utilize basic math operators, date and string functions. Additionally, you can model complex conditions using and/or support. Here are a few examples of Calculated Fields:
- Weighted Revenue: provides a single metric to help a sales representative prioritize an opportunity.
- Lead Score: provides a score to help a sales team follow up and prioritize the open sales leads.
- Invoice Due Date: adds a time period after the order was fulfilled.
Click to watch a short video showing you how rollup fields and calculated fields can now be created and configured using a simple interface.
has been working with Dynamics CRM for over 10 years - since CRM v1.2. We've helped many clients get the most out of CRM - even extending CRM to track information such as teachers, inventory, portfolios and more! Our and customer are proof!
If you are in the market for a new CRM solution or looking for ways to expand your existing CRM investment, we’d love to talk. or call 205-408-9991. As experts in as well as , we understand your challenges and can suggest practical solutions. We will help you achieve your strategic objectives faster…and may even help you add a few more achievements to the list.
