I was able to calculate an average from figures in a subtable by dividing SUMIFS by COUNTIFS. But how can I calculate the Median, Max, or Min similarly?
In Excel, you can use a formula similar to the solutions here: https://www.mrexcel.com/forum/excel-questions/336449-how-calc-median-average-max-based-condition-like-sumif-kinda.html
Would there be a way to do this in Ragic?
Example: MEDIAN(IF(A1==‘0’,B1)) does not seem to work.