Hi Juan On Wed, Jun 20, 2012 at 3:47 PM, Juan Pechiar <j...@pechiar.com> wrote: > From the manual (section 3.5.6 Column Formulas): > > If the table contains horizontal separator hlines, everything before > the first such line is considered part of the table header and will > not be modified by column formulas.
Yes, of course, I should know! I read this some years ago but didn't realize then what effect it will have for me one day: All rows in my current example except the last one are just considered as the table header and everything becomes clear. How could I not conclude myself. Thank you for helping out. With this in mind it should be | item | absolute | percent | |-------+----------+---------| | a | 17 | 34 | | b | 21 | 42 | | c | 12 | 24 | |-------+----------+---------| | total | 50 | 100 | #+TBLFM: @>$2=vsum(@<<$2..@>>$2)::$3=100 * $2 / @>$2 or |-------+----------+---------| | item | absolute | percent | |-------+----------+---------| | a | 17 | 34 | | b | 21 | 42 | | c | 12 | 24 | |-------+----------+---------| | total | 50 | 100 | |-------+----------+---------| #+TBLFM: @>$2=vsum(@<<$2..@>>$2)::$3=100 * $2 / @>$2 and it is not possible to take the shortcut of | a | 17 | | | b | 21 | | | c | 12 | | |-------+----+-----| | total | 50 | 100 | #+TBLFM: @>$2=vsum(@<$2..@>>$2)::$3=100 * $2 / @>$2 or |-------+----+-----| | a | 17 | | | b | 21 | | | c | 12 | | |-------+----+-----| | total | 50 | 100 | |-------+----+-----| #+TBLFM: @>$2=vsum(@<$2..@>>$2)::$3=100 * $2 / @>$2 to group rows with hline Michael
