Summary Level Formula
This section describes Summary Level Formula field.
Check out the illustration on creating a Formula Field at the Summary level.
The user can also create a formula field choosing the Summary Level as a level option from the Formula field editor window.
Navigate to the Design page of the report.
Click the Create Calculated Field icon.
The Create Calculated Field window appears.
Navigate to the Formula tab (It is the default tab).
Give a name to the new field.
Choose Summary Level from the Level drop-down menu.
Select a Save as option (It allows only Measure as the Save As option).
Select fields using the Fields tab.
Select an Operator from the Operators column.
Enter a Formula Expression using the Fields and Operators.
Click the Save option.
A notification message ensures that the Formula field is created.
A new Formula Field gets created and added to the list of dimensions and measures.
Add the newly created Formula Field to the top bar together with the earlier existing columns taken to create the new column.
Click the GO option.
The Formula Field data gets displayed in the current View for the users to validate the Formula.
Please Note:
The Summary level Formula Field only gets saved as a Measure. It can't be saved as a Dimension to the Data Store.
Summary Level will not be listed for the space where the MongoDB server is configured in the Admin Settings.
