Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Rolling up with Two Fields

455 2
Showing results for 
Search instead for 
Did you mean: 

I have Table (Pay Records) that is a list of records of when we pay staff. The table has a linked record to a Pay Month table which is a list of months/year (Dec 2020, Jan 2021, etc…). A Staff can have more than 1 Pay Record for a month.

In the Pay Month table, I have a record for Dec 2020, for example, and the linked field to Pay Records has mulitple records, which are all records in Pay Records paid in Dec 2020. This is all corect.

I would like to have a list of Staff and a Rollup of their pay, as some staff could be paid more than once in Dec 2020.

Any advise on how to achieve this? Super thanks in advance.

2 Replies 2

Screen Shot 2022-01-22 at 00.21.37

Maybe a little more specific from my side: I would like to have a list of Staff and a rollup of how much each got paid, for each month.

So far, I can create a Rollup field for all amount paid, to all staff, for a specific month. But cnanot get around to figuring out how to list each staff and a rollup amount for a each month.