# Average of filtered inline list

**URL:** <https://community.glideapps.com/t/average-of-filtered-inline-list/48793>\
**Category:** Ask for Help\
**Created:** [September 7, 2022, 1:05pm UTC](https://community.glideapps.com/t/average-of-filtered-inline-list/48793 "2022-09-07T13:05:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\
**Post date:** [September 7, 2022, 1:05pm UTC](https://community.glideapps.com/t/average-of-filtered-inline-list/48793/1 "2022-09-07T13:05:45Z")

</div>

I have complex filtering in an inline list (blood pressures.) I want to display the average valu for filtered rows. Is it feasible without much ado? (for chart it is not possible without internal relation and count)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 7, 2022, 3:05pm UTC](https://community.glideapps.com/t/average-of-filtered-inline-list/48793/2 "2022-09-07T15:05:55Z")

</div>

You can’t do any sort of summing or calculate averages on a filtered table. That has to be handled in the data.

What I would suggest is to replicate your filters with an IF column. That IF column could ultimately return a true/false result or you could actually have it return the number you want to use for your average.

Doing it that way you have a single value that you can use for both your filter as well as using it with a Rollup column to calculate the average.

---

<div class="post-metadata">

**Author:** ![Miroslav\_Madaric](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miroslav_madaric/32/20852_2.png) [@Miroslav\_Madaric](https://community.glideapps.com/u/Miroslav_Madaric)\
**Post date:** [September 11, 2022, 3:10pm UTC](https://community.glideapps.com/t/average-of-filtered-inline-list/48793/3 "2022-09-11T15:10:53Z")

</div>

I have solved the problem with that, tnx!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 12, 2022, 3:11pm UTC](https://community.glideapps.com/t/average-of-filtered-inline-list/48793/4 "2022-09-12T15:11:07Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.