>>> "ESF" == Eric S Fraga <e.fr...@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
smime.p7s
Description: S/MIME cryptographic signature
