Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for
Did you mean:
Not applicable

## avg value showing wrong

hi,

i have one small issue in pivot table

in avg column total  average value showing wrong

what i have to did to show correct value

1 Solution

Accepted Solutions
Not applicable
Author
9 Replies
MVP

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))

Not applicable
Author

thank you  tresesco

but i want the average of total value

MVP

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

Not applicable
Author

yes

Not applicable
Author

average of total avg

MVP

Isn't that 22.22 ?

Not applicable
Author

actually average of total value is22.59

but here showing 22.22

Not applicable
Author

Not applicable
Author

thank you so much  gyhxmg111

Community Browser