Adding Items in field and then subtracting them from another field

Hi peeps

I am new to Airtable and am starting to get the hang of counts, etc which I use to add up the number of items in a field. The fields are a form completed that will drop in a linked field from another table. I can add those up per row and get a sum per user like so:

Each line is the completion of a form by a user with them adding their details each time. What I want to to now is either change the form to:

A. add the same item to a user to create one line and one total
B. subtract the sum of all the items the user added from a set total

So if there are 50 items and they have gone in 3 times and chosen 15 over the 3 times, the total would reflect as 35 somewhere. This can be a single row or at the top of the sorted list, I dont mind. We just want to get all users to complete all tasks.

Does anyone have any suggestions? Open to linking the users from another table if that helps.

Thanks

What I want to do now is add

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.