Calculating and average between bases

Hello!

I have multiple bases that need to remain separate and one primary base where I need to track the average of a ranking between the other bases. Is there a way to reference a specific value in each of these other bases and display the average? I’ve only been seeing posts and videos about how to calculate an average from different tables within the same base. Also is there a way to make this a weighted average?

Will I need to sync/copy these separate bases into the primary base to then calculate the average of the field?

Thanks in advance!

1 Like

Hey Heidi,

Yes, you’ll need to sync the bases to one. You can then create formulas, rollups, and lookups to calculate the information.

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