[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
## Re: table: problem with nan and if

**From**: |
Uwe Brauer |

**Subject**: |
Re: table: problem with nan and if |

**Date**: |
Mon, 21 Jun 2021 20:58:46 +0200 |

**User-agent**: |
Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) |

>*>> "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

**
**`smime.p7s`

*Description:* S/MIME cryptographic signature