Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Calculating % change from values in one column
Answers
-
Hi Legends
Thought I should just update you on this. With all the input you provided I decided to tackle it as below:
To calculate the growth column, I duplicated the result column and filtered it by the minimum factor or lowest factor which as I mentioned is our starting point (Call it static result). I then summed it so that it repeats for all rows.I then used the growth formula which I typed wrong above should have been ((result - static result)/ static result) * 100. Problem solved!!!
Thank you all !!!
0 -
Can you please close the thread? (I guess "assumed answered" is the best matching as the answer is that you asked something else ...)
0 -
As usual love for the direct replies but none for conceptual ones dealing with understanding things :-P
0