Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Get average of test results for each item from another table

Topic Labels: Formulas
Solved
Jump to Solution
353 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I set up a database to help me organize battery cells and figure out which are good and bad. I have a table for each make & model’s rated specs, a table with the results for the each battery cell’s capacity test (each test is a record and a battery cell can have multiple tests/records) and a table for each battery cells’ details & summary. In the battery cells detail table I want a field for each battery cell that is populated with the average result of all it’s capacity tests from the capacity tests table. How do I achieve this?

P.S. - The value in question from the capacity test table is a number/integer (i.e., 2400).

1 Solution

Accepted Solutions

You will need to manually link each battery record to all of its battery test records (using a linked record field).

Then you can create a Rollup field to give you the average of all its battery tests.

See Solution in Thread

3 Replies 3

You will need to manually link each battery record to all of its battery test records (using a linked record field).

Then you can create a Rollup field to give you the average of all its battery tests.

Thanks! That did the trick exactly. I was originally trying do to this using the formula field type and FIND and LEFT commands, but got nothing but errors.

Thanks again.

You’re welcome! Glad I could help!