tables icon indicating copy to clipboard operation
tables copied to clipboard

Rudimentary Math

Open frankmcc opened this issue 1 year ago • 4 comments

Is your feature request related to a problem? Please describe.

Currently, there is no way other than manually, to sum or total columns. It would also be beneficial to sum multiple columns by referencing them.

Describe the solution you'd like

simple math to add referenced columns or to total single columns. No need for formulas, just selecting sum, adding or subtracting.

Describe alternatives you've considered

Spreadsheets, ugh...

Additional context

Tracking the cost of parts or labor in a maintenance log

frankmcc avatar Feb 29 '24 14:02 frankmcc

@frankmcc What do you mean by "sum multiple columns"? You mean count the total number of columns in a table?

enjeck avatar Mar 02 '24 16:03 enjeck

@frankmcc What do you mean by "sum multiple columns"? You mean count the total number of columns in a table?

Similar to a spreadsheet, but but much simpler, doing the simple math (Add, Subtract, Multiply and Divide) on the data contained in the column and rows then doing the same math for referenced totals:

-----------------|-------------------|-----------------------------
column1          |     column2       |      column 3 
-----------------|-------------------|-----------------------------
Number 1         |  Number 2         | = TotalRow1 (Number1 + Number2)
Number 3         |  Number 4         | = TotalRow2 (Number3 + Number 4) 
-----------------|-------------------|-----------------------------
=TotalCloumn1    | = TotalColumn2    | =  TotalColumn3
(Number1+        |  Number2+         |   (TotalRow1+
Number3)         |  Number4)         |   TotalRow2)

frankmcc avatar Mar 04 '24 13:03 frankmcc

Related: https://github.com/nextcloud/tables/issues/36

enjeck avatar Mar 13 '24 13:03 enjeck