Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

How to include a computed column in a report

Updated on September 20, 2019


You can display a value for a column of a list view report that is computed from other columns.

Note: this method is available for Process Commander Versions 5.4 and earlier only.

For example, if there are properties named Width and Height, you could include a column named Area computed as Width times Height. In addition, for summary views, you can specify a column that counts, totals or averages work objects for properties in the report.


Suggested Approach

Computed columns in list views

  1. Before you begin, identify the properties whose computed value will be displayed in a column of your list view. In the example, the properties are OrderTotal and QuantityTotal. They will be used to show the average price per unit. The figure shows the properties listed in the Application Explorer tree along with their declarative expressions.


  2. Create a property alias rule to define the computed column. The Property Alias rule should be created in the same class as the list view class. In the example, the alias rule is ComputedAverage.


  3. Enter the Alias Reference. This is the expression used to compute the two property values.
  4. Choose the Resulting Property Type from the drop-down list.
  5. In the Category field, choose Expression from the SmartPrompt list.


  6. Create a list view that includes the properties whose value will be computed. Enter the properties in both the Content and Display Fields tabs.
  7. In the Display Fields tab, create a new row in the Show These Fields section, Field column.
  8. Click the spyglass-shaped Search icon (zzz) next to the field.


  9. In the Pick an Expression window, select the new property alias expression, then click Apply.


  10. Enter a Field Label for the column head. In the example, the computed column is ComputedAverage.


  11. Click the Save icon.
  12. Click the Run icon. The report displays with the new computed column.


Computed columns in summary views

To include a computed column in a summary view:

  1. Create or edit a summary view and specify the Group By field to display.
  2. In the Fields section of the Content tab, choose a Function from the drop-down list. In the example, the report will display the count of the orders and the average total for purchase orders.
    Note: For the Count Distinct, Sum, Average, Min, and Max functions, you must specify a property in the Field field. Make sure that the property is exposed as a column. To expose the property, see How to expose a work object property as a column and update data views.
  3. Enter a text Caption to display as a column head.


  4. Click the Save icon.
  5. Click the Run icon. The report displays with the specified computed column and column head.



Pega Platform 7.1.1 - 7.4 Reporting Financial Services Healthcare and Life Sciences Insurance Communications and Media Government Healthcare and Life Sciences Consumer Services Consumer Services Manufacturing Consumer Services

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us