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)
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.
3 Likes
I have solved the problem with that, tnx!
1 Like
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.