Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 231 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Enable Row-Based Difference Calculations and Ratio Summations in Oracle Analytics Cloud
User_SHXB2
Rank 1 - Community Starter
Currently, Oracle Analytics Cloud only supports difference calculations and percentage calculations across columns, not rows. This limitation causes inaccurate summations—especially when calculating metrics like (current year balance - prior year balance) / prior year balance for total percentages or when a row-based summation is required.
We request a feature that allows users to perform difference calculations total, ratio, and percentage calculations based on row values, ensuring accurate aggregations for financial and analytical use cases.
Implementing this enhancement will offer flexibility and resolve unexpected results due to column-only calculations.
7