My Oracle Support Banner

Complex Operation With Agregate Functions Are Not Taking Into Account The Group By Field (Doc ID 1435083.1)

Last updated on APRIL 23, 2019

Applies to:

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


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.


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

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