Calculate Average with Rule


I have the following integer column with 376000 rows, the content looks like that:


I want to calculate the average including only the values <=52.  How can I do that?


Row Splitter (or Filter) on value range (upper threshold 52) followed by simple average of the filtered table?A one-node solution would possibly require Java.


Hi Ergonomist,

The proposed solution is not a good option. because it filters out rows, something that should not happen because the column is not standalone, is part of a table and thus it filters rows also from the other columns.


I took a Math formula node and run the following expression:


Conditional math is decidedly more elegant, I'll admit that much! Likely will not keep me from my usual table acrobatics, though. :-)