Le 02/08/2017 14:07, Karl Voit a écrit : > Hi! > > How can I determine minimum and/or maximum value of a table? > > Here is my example: > > #+NAME: myvalues > | Values | > |--------| > | 4 | > | 2 | > | 3 | > | 7 | > | 5 | > | 6 | > > | Min | Max | Average | First | Last | > |--------+--------+---------+-------+------| > | #ERROR | #ERROR | 4.5 | 4 | 6 | > #+TBLFM: @2$1='(min (remote(myvalues,@2$1..@>$1)))::@2$2='(max > (remote(myvalues,@2$1..@>$1)))::@2$3=vmean(remote(myvalues,@2$1..@>$1))::@2$4=remote(myvalues,@2$1)::@2$5=remote(myvalues,@>$1) > > My goal is to get min==2 in the first column and max==7 in the > second. >
Alternatively you have the orgtbl-aggregate package available on Melpa. #+BEGIN: aggregate :table "myvalues" :cols "min(Values) max(Values) mean(Values)" | min(Values) | max(Values) | mean(Values) | |-------------+-------------+--------------| | 2 | 7 | 4.5 | #+END:
