Avg calculation based on dimension column — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Avg calculation based on dimension column

Received Response
1
Views
1
Comments
user12301120
user12301120 Rank 1 - Community Starter

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

  • P G
    P G Rank 3 - Community Apprentice

    Hi,

    you can apply below formula on third column.

    avg(amount)= Amount / count(region)

    eg.

    pastedImage_0.png