Re: table: problem with nan and if

[Uwe Brauer <oub@mat.ucm.es>]

[-- Attachment #1: Type: text/plain, Size: 1303 bytes --]

>>> "ESF" == Eric S Fraga <e.fraga@ucl.ac.uk> writes:

> Uwe,
> it might be easier if you explained what it is you want to do (at a
> higher level) instead of trying to get us to help to fix what you have
> done?

OK fair enough 


The situation is as follows, there are two exams


    1. The result of the first one is calculated as: E1+E2+E3=Result-Ex1

    2. The second one Result-Ex2 (column 6, I have extracted from another table via

#+BEGIN: aggregate :table Ex1 :cols "Name  'Result-Ex1 "
But this is not important here.

What is important is how the columns $5, and $7 are calculated.
If column $2,$3, and $4 are non empty $5 is just the sum of these.

The problem is $7:

    1. it should be the sum of $5 and $6, *even* if $5 is empty,

    2. but it should be empty if $6 is empty.



#+begin_src elisp

#+NAME: test
| Name  | E1 | E2 |  E3 | Result-Ex1 | Result-Ex2 | Final |
|-------+----+----+-----+------------+------------+-------|
| User1 |    |    |     |            |          8 |       |
| User2 |    |    |     |            |            |       |
| User3 |  1 |  0 | 3.5 |        4.5 |        5.8 |   4.8 |
|-------+----+----+-----+------------+------------+-------|
#+end_src



Did I explain this detailed and clear enough?

Uwe 

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]