Group data by Year

[ishita_shah]

I have data with the following columns:

1. Date
2. Income
   3.Expense
   How do I calculate the savings by year? I have already Extracted year from the date.

[Darren_Murphy]

• create a multiple relation column that matches the year with itself
• use two rollup->sum columns to get totals for each of income and expenses via the relation
• use a math column to subtract total expenses from total income

[ishita_shah]

This is the first app I am building and have no knowledge about any of this. Can you elaborate on the relation columns?
When i try to create one that matches year with itself it shows the data from the categories column.

These are the columns that I have

[Jeff_Hager]

What the relation actually shows as a result is irrelevant. It’s creating a connection to ROWS, not a specific column. If you see anything in a relation column, that means it returned all Rows that have matching values in the columns you used to create the relation.

After creating the relation, did you follow the rest of @Darren_Murphy’s steps?

[ishita_shah]

Yes! I got it. Thank you so much.

[ishita_shah]

It worked! Thank you so much