Get average of test results for each item from another table

Question

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).

ScottWorld · Accepted Answer

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.

dubbayoo · Answer

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.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded