Grand Total of Rows

[Wendy_Yelsik]

I need to export a grand total number from Airtable to import into our payroll software as a csv.   The table is setup by an employee and that employee has a new row for each month of the year with a number in it.   I know that airtable sums those columns, but I don't know how to export the grand total by employee.   I need the grand total of the {Dollar$} field exported.  How can I do this?   Thanks. Wendy

[TheTimeSavingCo]

Hi Wendy, to do that you'll need to create another table, link your records as needed, and use a rollup field with the formula "SUM(values)" I'm afraid

[Wendy_Yelsik]

Thanks.   I linked a new table (table 2) to the table with the dollar amounts (table 1).  When I roll up the dollar field from table 1 to the rollup field in table 2, I get a $0.   I linked table 2 to table 1 using the employee number.   Not sure what I am doing wrong; likely something simple :).  

[TheTimeSavingCo]

Ahh, that's odd.  Could you share some screenshots of the relevant tables and fields so that I can help you troubleshoot?

[Wendy_Yelsik]

Hi, Adam.  I decided to enter my data into our payroll system manually.    I am retiring the base I used for this information and recreating a more organized one.   Thank you for the response and help!   - Wendy