Support Article

Calculation Builder opens when Filter is selected in Report



When running Report Definitions, if user clicks on a field seen in "Filter by:" area and the Edit Filter section is shown with the option to open the Calculation Builder.

The Calculation Builder being available to business users causes confusion.

Error Messages

Not Applicable

Steps to Reproduce

  1. Run a Report Definition.
  2. Click a field in the "Filtered by:" area.
  3. Click the fx button and a Calculation Builder modal appears.

Root Cause

This behavior is as per design.
The corresponding section rule pzEditSingleFilter is a ‘Final’ rule and contains the pzOpenSQLExpressionBuilder control for the calculation builder.


The calculation builder may appear as complicated to business users.
An enhancement request, FDBK-18052​, has been created for consideration by Pega Product Management.

Published January 30, 2017 - Updated February 7, 2017

Have a question? Get answers now.

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