Complex Operation With Agregate Functions Are Not Taking Into Account The Group By Field

(Doc ID 1435083.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle SOA Platform – BAM (Business Activity Monitoring) - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When creating a calculated field that is an aggregate expression, such as SUM(Sales), then when you add that field to a grouped view like a chart the values that are displayed are the aggregate values for each group.
If you modify the calculated field by adding additional operations, such as SUM(Sales)+1 or SUM(Sales)-SUM(Costs) or use the calculated field in another calculated field, such as Calculation1+1, then the grouping is no longer done.  The same value is displayed for each group which is the aggregate value for all groups together.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms