Total Row Value Is Incorrect and Randomly Changes With Sort Order in Analytics
(Doc ID 3035113.1)
Last updated on JULY 16, 2024
Applies to:
Oracle Business Intelligence Enterprise Edition - Version 12.2.1.0.0 and laterOracle Analytics Cloud - Version 105.4.5 and later
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
Symptoms
You have created a formula with conditions such as Case or If and are using a data source that does not have an aggregation method defined on it.
You are using this formula in a Classic Analysis or DV Workbook Table or Pivot Table.
Default Aggregation is set on that column to produce a Total Row.
The Total Row values for that column are not correct and are not explained by Sum, Average or any other function.
Changing the sort order of the rows may even change the value of the Total Row, but the values are still deemed to be incorrect.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |