Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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 |