search

nextcloud / tables

🍱 Nextcloud tables app
https://apps.nextcloud.com/apps/tables
GNU Affero General Public License v3.0
143 stars 24 forks source link

Rudimentary Math #888

Open frankmcc opened 7 months ago

frankmcc commented 7 months ago

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

enjeck commented 7 months ago

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

frankmcc commented 7 months ago

@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)
enjeck commented 6 months ago

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