Help

How can I access the sum of another table in a formula in another table?

4208 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dan_McComb
4 - Data Explorer
4 - Data Explorer

I’m creating a budget app, and want to use the SUM of another table (all rows) in a formula to calculate percentage in another table. Is there a way to reference that SUM in a formula?
I haven’t been able to find it in the docs…

Thanks, Dan

2 Replies 2

Make sure that every record in table #1 is linked to table #2. That could be anything. A month, a week or any random number. As long as all records are related to that specific single record in table #2.

Then, in table #2, create a ROLLUP field. In that ROLLUP field you will be asked which field you want to roll up. Pick the specific field in table #1 with the amount you would like to sum.

In the last box in your ROLLUP field, choose SUM(values) and voila.

Dan_McComb
4 - Data Explorer
4 - Data Explorer

Thanks Andre,
I figured it out. In my case, what I needed to do was create a calc table that contains only one record, and link it to every record in table A. Then, I was able to get a rollup of every record in the table B into one cell. Then I was able to reference that from table A, where I needed the number to perform the calculation. It’s clunky, but it works.