Re: how to exclude certain row values from calculation in a table

[Bruno Barbier]

Hi Uwe,

Uwe Brauer <oub@mat.ucm.es> writes:

> Hi all
>
> Please look at 
>
> |   |  Price |
> |---+--------|
> | / |  10.98 |
> |   |  11.90 |
> |   |  19.98 |
> |   |  13.79 |
> |   |  29.97 |
> |   |  18.98 |
> |   |  13.79 |
> |   |  11.90 |
> |   |  24.28 |
> |---+--------|
> |   | 155.57 |
> #+TBLFM: @11$2=vsum(@I$2..@II$2);f2
>
> I would like to exclude the first value from the sum by adding some mark
> in that row.
...
>
> Any idea how to exclude row values in a column?

You could use 'vmask' to mask the values you don't want.
Here is an example using vmask:

   |                |  Price |
   |----------------+--------|
   | 1              |  10.98 |
   |                |  11.90 |
   |                |  19.98 |
   |                |  13.79 |
   | 1              |  29.97 |
   |                |  18.98 |
   |                |  13.79 |
   |                |  11.90 |
   |                |  24.28 |
   |----------------+--------|
   |                | 155.57 |
   | Total unmarked | 114.62 |
   | Total marked   |  40.95 |
   | Check all      |     OK |
   #+TBLFM: @11$2=vsum(@I$2..@II$2);f2
   #+TBLFM: @12$2=vsum(vmask(map(<0 = #1>, @I$1..@II$1), @I$2..@II$2));f2NE
   #+TBLFM: @13$2=vsum(vmask(map(<1 = #1>, @I$1..@II$1), @I$2..@II$2));f2NE
   #+TBLFM: @14$2=string(if(@12$2+@13$2 = @11$2, "OK", "Oops!"))

Bruno