Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OAC calculation formula simplification

Description
Simplify the ability to use and create pre-existing calculations for use in other desired formulas similar to Excel functionality. for example, when calculating a ratio that divides formula 1/formula 2 - in excel you simply take cell number where formula 1 output is located and divide by cell number where formula 2 is located to calculate a ratio regardless of the complexity involved in the first two formulas. In OAC, this functionality does not exist and creates the occasional need to take data out of OAC and put in Excel to easily modify and create additional calculations -or- construct in OAC re-creating complex calculations that are already in place..
Use Case and Business Need
The premise of this idea is to more easily allow direct use in OAC of calculated numbers in subsequent calculations. Ratios are very common in analytics, dashboards, and KPI measurement so I expect this idea will enable users across industries to better leverage direct and singular use of OAC to meet needs when complex formulas are involved.
More details
I occasionally need to take data out of OAC and work with Excel to save time.
Original Idea Number: 55370bb8fd