"Daniel E. Doherty" <d...@ddoherty.net> writes: > | Description | Amount | > |--------------+------------| > | Mortage | 125,000.26 | > | Credit Cards | 6,325.00 | > | Auto Loan | 14,853.00 | > |--------------+------------| > | Total | 1323.26 | > #+TBLFM: @5$2=vsum(@I..@II) > > Note that the total is wrong.
Well. This is also a caveat from calc, unfortunately. 7.7.2 Grouping Digits Please note that grouped numbers will not generally be parsed correctly if re-read in textual form, say by the use of ‘C-x * y’ and ‘C-x * g’. (*Note Kill and Yank::, for details on these commands.) One exception is the ‘\,’ separator, which doesn’t interfere with parsing because it is ignored by TeX language mode. So, you can instead do | Description | Amount | |--------------+-------------| | Mortage | 125\,000.26 | | Credit Cards | 6\,325.00 | | Auto Loan | 14\,853.00 | |--------------+-------------| | Total | 146178.26 | #+TBLFM: @5$2=vsum(@I..@II) Or with #+begin_SRC emacs-lisp (setq org-calc-default-modes '( calc-internal-prec 12 calc-float-format (float 8) calc-angle-mode deg calc-prefer-frac nil calc-symbolic-mode nil calc-language latex ;; <--- this is new compared to default, enable latex symbols calc-group-digits t ;; <--- group digits in the results calc-group-char "\\," calc-date-format (YYYY "-" MM "-" DD " " Www (" " hh ":" mm)) calc-display-working-message t)) #+end_SRC | Description | Amount | |--------------+-------------| | Mortage | 125\,000.26 | | Credit Cards | 6\,325.00 | | Auto Loan | 14\,853.00 | |--------------+-------------| | Total | 146\,178.26 | #+TBLFM: @5$2=vsum(@I..@II) > | Description | Amount | > |--------------+----------------------------| > | Mortage | \dollar 125000.26 | > | Credit Cards | 6325.00 | > | Auto Loan | 14853.00 | > |--------------+----------------------------| > | Total | 125000.26 \dollar + 21178. | > #+TBLFM: @5$2=vsum(@I..@II) > > Total is still wrong. You need | Description | Amount | |--------------+----------------------------| | Mortage | \dollar 125000.26 | | Credit Cards | \dollar 6325.00 | | Auto Loan | \dollar 14853.00 | |--------------+----------------------------| | Total | 146178.26 \dollar | #+TBLFM: @5$2=vsum(@I..@II) Best, Ihor