Differences

This shows you the differences between two versions of the page.

--- tabletest [2022/11/13 21:49] – created Alan Shea
+++ tabletest [2022/11/13 21:55] – Alan Shea
@@ Line 4: / Line 4: @@
-|  **//Total://** ^  $~~=sum(items_1.c5r1:c5r99)~~ ^
+|  **//Total://** ^  $~~=round(sum(items_1.c5r1:c5r99),2)~~ ^
+| Total should be $15500.00||
@@ Line 11: / Line 12: @@
 |  ~~=cell(0,row()-1)+1~~   | NT855-G6 LONG  | Cummins NT855-G6, CPL 1381 Reman Long Block  |  ea    |  1     |  15500.00 |  ~~=cell(4,row())*cell(5,row())~~ |                |
 |  ~~=cell(0,row()-1)+1~~   | CORE           | Block Core charge                            |  ea    |  1     |   4000.00 |  ~~=cell(4,row())*cell(5,row())~~ |                |
-|  ~~=cell(0,row()-1)+1~~   | LTL            | Freight to 17522, Ephrata, PA                |  ea    |  1     |   1420.00 |  ~~=cell(4,row())*cell(5,row())~~ |                |
+|  ~~=cell(0,row()-1)+1~~   | LTL            | Freight                 |  ea    |  1     |   1420.00 |  ~~=cell(4,row())*cell(5,row())~~ |                |
 |  ~~=cell(0,row()-1)+1~~   | TAX            | Sales Tax                                    |  ea    |  0     |         0 |  ~~=cell(4,row())*cell(5,row())~~ |                |
-|  **//Total://** ^  $~~=sum(items_2.c5r1:c5r99)~~ ^
+|  **//Total://** ^  $~~=round(sum(items_2.c5r1:c5r99),2)~~ ^
+| Total should be $20920.00||
+See https://forum.dokuwiki.org/d/20026-tablecalc-stops-sum-after-too-many-entries/

MetaTek

User Tools

Site Tools

Differences

Page Tools