Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 38 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 274 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Row-Level Aggregate not Functioning As Expected
The row-level aggregate function is not working as expected.
I have the table below with rows A, B, and C. There are three values 1, 2, and 3. The percentage is calculated as Val 2 + Val 3 / Val 1 (ex. 348+200/620 = 88.39). I am then using the row-level aggregate to determine the total for all of the categories (shown in bold). This function is working as expected when aggregating Val 1, Val 2, and Val 3. However, it is not calculating the percentage correctly. Rather than calculating the percentage as (1152 + 206 / 2260 = 60.09), it is calculating the percentage by taking an average of the percentages for the lines within the total (88.39+48.56+50.27/3 = 62.41)
I have tried using all of the different aggregation settings and cannot determine a solution. Would anyone know of a workaround for the row-level aggregation function so that it can work as I intended?
| Category | Val 1 | Val 2 | Val 3 | Percentage |
|---|---|---|---|---|
| A | 620 | 348 | 200 | 88.39 |
| B | 904 | 437 | 3 | 48.56 |
| C | 736 | 367 | 3 | 50.27 |
| Category Total | 2260 | 1152 | 206 | 60.09//62.41 |