top 10 average is not calculated correctly

[alis2063]

Hi All,

I have produced the Advanced purchased report & wanted to calculate the Average Fare

Avg Fare= '0-4 Day Total $$/0-4 Day Sectors'

Its working for City pairs but total Calculation is getting wrong

I.e 647,425/995=650.1 -Is correct

     7473422/11087 979 is wrong

!

[Kushal_Chawda]

try this

=sum(aggr( 0-4 Day Total $$/0-4 Day Sectors, CityPair))

[alis2063]

Its not working as its Top 10 city pairs

[Anil_Babu_Samineni]

Would you mine, Can you share sample to test

[alis2063]

Pease look into snapshot