Roll-up summary fields are the values that automatically display on a master record based on the values of records in a detail record.

Navigating the Rollups Page

When you launch the rollups page on the UI, all the existing rollups are listed on this page along with their details. There are various functionalities available for you to manage the rollups.

Rollups Search

You can narrow down the rollups list using the search feature. You can either define search criteria to search for a range of rollups or use the rollup search option.

Basic Search

In basic search, you can search for a rollup using keywords. For example, you can search using the name of the rollup. 

  1. In the Search this list field, enter a keyword related to your rollup details such as rollup name.
  2. Click the search icon  or press Enter. CPQ returns all rollups that contain that keyword in the rollup names.

Advanced Search

In advanced search, you can search for a rollup using a search query. The search query uses options provided in the Field, Operator, and Value and displays a search result that matches the criteria.

  1. Click the Advanced Search icon . The Advanced Search pop-up is displayed.
  2. Enter the following details: 
    1. Field: All rollup fields are available in the drop-down list such as Name, Is Active and Last Modified Date.
    2. Operator: Operators that are available for selection helps create the filter expression. Operators are displayed based on the field types. For example, a picklist value will display equal to and not equal operators and a text field will display equal to, not equal to, starts with, contain, does not contain operators. If it is a multi-value picklist, the application displays include and does not include operators.
    3. Value: Enter a value.
  3. Click Add Criteria if you want add more criteria in the advanced search.
  4. Turn the Logic button on if you have more than one criteria and enter a value in the Logic field.
  5. Click Apply to enable the search filter. CPQ returns all rollups that match the criteria.

Sorting Rollups

You can sort the rollups list by clicking the column names. The rollups are sorted alphabetically in ascending order using the rollup name. Every time you click the column name, the sorting switches between ascending and descending order. You can adjust the column width by dragging the columns. Hover near the column boundaries till two-way arrow appears. Click when the arrow appears and drag left or right to adjust the column width.

Actions available on this page

  • Click Create New to create a new rollup.
  • Click the ellipsis icon  next to the rollup name to edit an existing rollup.
  • Click the rollup name link to open the rollup Details page.

Items per page

At the bottom of the page, you can see the total count of rollups available. You can control the number of rollups to be displayed on each page. You can select the number of rollups from a predefined list. You cannot configure this list. By default, you see 20 records on each page.

By default, you can sort 10, 20, 30, 50, and 100 rollups per page using the Rows per page drop-down. This feature works in association with the search and filter functions to display search records per page. You can use the < and > buttons to move to the next or the previous pages. You can also jump to a certain page using the page search component.

Navigating the Rollups Details page

  1. Go to ADMIN SETUP > Product Administration > Rollups
  2. Search for the rollup you want to update.
  3. Click the rollups name link to open the rollups details page.

Actions available on this page

  • On the Details tab, edit the rollup details.