

Partner - Creator II
2018-11-26
06:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Average per Customer
Hi There,
i want to calculate an Average Prive per Item per Customer.
But i am Stuck 😞
The average is not correct, if there are 2 Prices per customer. I Played around with aggr and total, but it is not working.
I want the average of the average per customer (see attached Excel) as an result. But it is not Working 😞
I rellay would appriciate some help!
Thanks
Fabian
2,972 Views
1 Solution
Accepted Solutions

MVP
2018-11-26
07:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think this is what you need
=Avg(Aggr(Avg(Price),Customer))
But for some reason, you excluded Customer I for your expected output. If you want to exclude I, you can try this
=Avg({<Customer -= {'I'}>}Aggr(Avg(Price),Customer))
3 Replies

MVP
2018-11-26
07:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think this is what you need
=Avg(Aggr(Avg(Price),Customer))
But for some reason, you excluded Customer I for your expected output. If you want to exclude I, you can try this
=Avg({<Customer -= {'I'}>}Aggr(Avg(Price),Customer))

MVP
2018-11-26
07:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
=Avg(Aggr(avg(Price), Customer))
=Avg(Aggr(avg(Price), Customer))


Partner - Creator II
2018-11-26
07:20 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks @sunny_talwar, it works.
I did not want to exclude I, i made mistake 😞
2,958 Views
