Calculating and average between bases

[Heidi_Wussow]

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!

[Hannah_Wiginton]

Hey Heidi,

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

Airtable Support

Airtable Sync - Basic setup

Using Airtable Sync, you can sync records from a source base to one or more destination bases to create single sources of truth across your organization. IN THIS ARTICLE OverviewSetting up a syncF...

Airtable Support

Multi-source syncing

Multi-source sync allows you to bring information from multiple sources into a single, centralized destination table. The records residing in each of the sources are aggregated together in the dest...