Complex Operation With Agregate Functions Are Not Taking Into Account The Group By Field
Last updated on AUGUST 05, 2016
Applies to:Oracle SOA Platform – BAM (Business Activity Monitoring) - Version 18.104.22.168.0 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.
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