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