My Oracle Support Banner

Business Intelligence Publisher Enterprise Users Designing Layout Templates Report Error 'Aggregation Function Missing' When Creating A Custom Formula In A Pivot Table (Doc ID 2312274.1)

Last updated on FEBRUARY 25, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.9.x and later
Information in this document applies to any platform.

Goal

Business Intelligence Publisher 11.1.1.9 Enterprise, Designing Layout Templates issues

 

 

 

When creating a pivot table custom formula in BI Publisher layout editor, users receive the following error:

'This formula is not valid for the selected component. Reason: Aggregation function missing.'

For example, when defining a subtraction on a pivot table column in an XPT template type a custom Formula:

Function: Basic Math: Subtraction
Subtrahend: Total Std Cost

In the Parameter dialog box for the Subtrahend the 'Field' method is selected with value 'Total Std Cost', and the above error message is received.

Is it possible to define custom formulas in a Pivot table?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.