• 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

Exploring Field Types – Part 1: Rollup Fields

June 7, 2017   Microsoft Dynamics CRM
0000 300x225 Exploring Field Types – Part 1: Rollup Fields

Welcome to our two-part blog series on Field Types. In today’s entry, we’ll discuss Rollup Fields, including when and why to use them and how to add them. If the concept of a rollup field is completely unfamiliar, you can get a crash course here. If you’ve got even a basic understanding, you’re good to go. Let’s get started… Rollup fields allow for aggregation of data from multiple child records to a single parent record. They are a great tool when you have a parent opportunity to which you want to associate many potential child opportunities – everything is in one field! But there are plenty of other uses for a rollup field. For example, let’s say you want to track as tasks every piece of effort against an opportunity. Is all the effort the same? Of course not. Do some opportunities require 15 pieces of effort (tasks) while others need just one? Yep. Are there trends and correlations between number of tasks and the eventual outcome (win or lose)? Almost always! Well, rollup fields can help with all of this. So, let’s assume we want to easily see the number of tasks against each opportunity, as well as how many of those tasks have been completed at any given time. To accomplish this, we will first create two new rollup fields – one for associated tasks and the other for completed tasks. Note that to perform the tasks described, your security role must allow you to customize entities.

1.)Begin by creating the first of two new Fields – in our example below, we’ve named it Tasks. Set “Data Type” to Whole Number; set “Field Type” to Rollup.

060617 1526 ExploringFi1 Exploring Field Types – Part 1: Rollup Fields

2.)Click Edit to modify the properties of the Rollup field. Set “RELATED ENTITY” to Tasks and “AGGREGATION” to COUNT of Task, as shown:

060617 1526 ExploringFi2 Exploring Field Types – Part 1: Rollup Fields

3.)Next, create another new Field – in our example below, we’ve named it Tasks Completed. Once again, set “Data Type” to Whole Number; set “Field Type” to Rollup.

  • Note that including the word “Task” in both field names will make it easier to reference in other calculated fields. For example, in Part Two of our four-part series on calculated fields, we’ll discuss Percentage Fields.

060617 1526 ExploringFi3 Exploring Field Types – Part 1: Rollup Fields

4.)Click Edit to modify the properties of the Rollup field. Set “RELATED ENTITY” to Tasks, “FILTER” to If Activity Status equals ‘Completed,’ and “AGGREGATION” to COUNT of Task, as shown:

060617 1526 ExploringFi4 Exploring Field Types – Part 1: Rollup Fields

5.)Next, we need add our two newly-created fields to our Form and View. Before adding the new fields to the Form, however, we must first decide how we want them to appear: in an existing Section or in a newly-created dedicated Section. In our example, we’ve created a new Section, as shown below. (For more information on how to insert a new Section, see Customizing Entities.)

060617 1526 ExploringFi5 Exploring Field Types – Part 1: Rollup Fields

6.)Next, we need to add our new fields to a View, which is as simple as selecting the View and adding the columns. (For detailed information on how to do this, please see Customizing Views.)

060617 1526 ExploringFi6 Exploring Field Types – Part 1: Rollup Fields

7.)Publish all changes. When you first create Rollup fields, it may take up to 24 hours for the calculations to be applied, so don’t be alarmed if all the fields are blank initially, as shown below.

060617 1526 ExploringFi7 Exploring Field Types – Part 1: Rollup Fields

8.)Just keep checking back. Opening a Record and navigating to the Task fields you created will allow you to force a calculation:

060617 1526 ExploringFi8 Exploring Field Types – Part 1: Rollup Fields

Eventually, all your data will be populated, as shown:

060617 1526 ExploringFi9 Exploring Field Types – Part 1: Rollup Fields

And that’s it. We can now see the number of tasks associated with each opportunity, as well as how many of those tasks have been completed. Let the tracking, trending, and correlating begin! Hopefully, you found this helpful. As we said at the beginning, this is the first in a four-part series on Field Types. Stay tuned for more.

In the meantime, make sure to checkout our upcoming webinar, Dynamics 365 for Sales for SMB Enterprise Licenses, on June 7!

Happy CRM’ing!

Let’s block ads! (Why?)

PowerObjects- Bringing Focus to Dynamics CRM

Exploring, Field, Fields, Part, Rollup, types
  • 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