- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
avg value showing wrong
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you tresesco
but i want the average of total value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is your expected output (in number) as total average?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
average of total avg
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Isn't that 22.22 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
actually average of total value is22.59
but here showing 22.22
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you so much gyhxmg111