I’m a noob. I have 3 tables. Deductions, addi...

(John Key) #1

I’m a noob. I have 3 tables. Deductions, additions and then an overview table.

I’d like to add entries (in dollar amount) to deductions. I’d like to add entries (in dollar amount) to additions. And then finally make calculations in the overview table based off of the data from deductions and additions.

Is this possible? If so, what formulas do I use and where do I input them?

For example purposes,

Deductions table has:

Entry 1: -$7 Entry 2: -$10 Total: -$17

Additions table has:

Entry 1: $2 Entry 2: $5 Total: $7

Overview table has: Deductions: -$17 Additions: $7 Balance: -$10

Is this possible to create in app sheet?

(Aleksi Alkio) #2

Yes you can do that with a virtual column. Easier solution would be if you would have deductions and additions in a same table, but this doable as well. The formula could be like… IFS( [ColumnName]=“Deductions”, SUM(Deductions[ENTRY]), [ColumnName]=“Additions”, SUM(Additions[ENTRY]), [ColumnName]=“Balance”, SUM(Additions[ENTRY])+SUM(Deductions[ENTRY]) )