avg value showing wrong

[#1]

hi,

i have one small issue in pivot table

in avg column total  average value showing wrong

please help me

what i have to did to show correct value

[tresesco]

I guess total avg is showing correct (it is actually over all average). May be you are expecting to see total of all averages. If so, that could be achieved using Sum(aggr(Avg(... structure of formula. But before doing that I would suggest to consult your business if they really want that.

For row total (sum of all averages), try expression:

=Sum(Aggr(if(isnull(avg({$<RNUNTS_ACTIVE_ROW={Active}>}  RNUNTS_RENT_IN_SQFT/RNTS_TS_PERIOD_DIV_VAL)),avg({$<RNUNTS_ACTIVE_ROW={Active}>}  RNUNTS_RENT_IN_SQFT) ,avg({$<RNUNTS_ACTIVE_ROW={Active}>}  RNUNTS_RENT_IN_SQFT/RNTS_TS_PERIOD_DIV_VAL))

  ,Project,SubProject,Lesse))

[#3]

thank you  tresesco

but i want the average of total value

[tresesco]

What is your expected output (in number) as total average?

[#5]

yes

[#6]

average of total avg

[tresesco]

Isn't that 22.22 ?

[#8]

actually average of total value is22.59

but here showing 22.22

[#9 · Accepted solution]

[#10]

thank you so much  gyhxmg111