Re: How to exclude colum titles from calculations

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

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

>>> "FE" == Fraga, Eric <e.fraga@ucl.ac.uk> writes:

> I make extensive use of the advanced features of the spreadsheet in org
> tables, specifically having a first column that indicates which rows
> should be calculated or not.  Check out the org info manual

> (org) Advanced features


Aha, thanks 
meanwhile I tried

|   |       |      What |           |      This |           |
|---+-------+-----------+-----------+-----------+-----------|
| ! |       | Account 1 | Account 1 | Account 2 | Account 2 |
|---+-------+-----------+-----------+-----------+-----------|
|   | Item1 |    224999 |  56249.75 |    224999 |  56249.75 |
|   | Item2 |    269403 |  67350.75 |    269403 |  67350.75 |
|   | Item3 |           |           |           |           |
|   | Item4 |           |           |           |           |
|   | Item5 |     10300 |   2575.00 |           |           |
#+TBLFM: $4=if(typeof(0.25*$3) == 12, string(""),0.25*$3); E f-2::$6=if(typeof(0.25*$5) == 12, string(""),0.25*$5); E f-2

Or / instead of !, the problem is then this row is not exported.


So you propose

|   |       |      What |           |      This |           |
|---+-------+-----------+-----------+-----------+-----------|
|   |       | Account 1 | Account 1 | Account 2 | Account 2 |
| # | Item1 |    224999 |  56249.75 |    224999 |  56249.75 |
| # | Item2 |    269403 |  67350.75 |    269403 |  67350.75 |
| # | Item3 |           |           |           |           |
| # | Item4 |           |           |           |           |
| # | Item5 |     10300 |   2575.00 |           |           |
#+TBLFM: $4=if(typeof(0.25*$3) == 12, string(""),0.25*$3); E f-2::$6=if(typeof(0.25*$5) == 12, string(""),0.25*$5); E f-2

Which works nicely, thanks







-- 
Warning: Content may be disturbing to some audiences
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the ban of Russia from SWIFT.
I support the EU membership of the Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/

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