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
Avg calculation based on dimension column

Hi Guru's,
I know, I was asking basic thing but not able to solve my issue can anyone help me out on this issue.
In report i have two columns 1. Region 2. Amount
My requirement is : I want calculate average based on region.
Region amount Avg(Amount)
I did all below methods but it is showing wrong avg numbers.
1. In third column --> avg(amount by region)
2. avg(amount/amount)
3. avg(amount/(sum(amount by region)*100.0)
no luck.
Can you anyone suggest any inputs to solve this issue highly appreciated.
Thanks,
User12301120
Answers
-
Hi,
you can apply below formula on third column.
avg(amount)= Amount / count(region)
eg.
0