Can I reference rows of data in a separate table to perform an average in the table I am working on?
Additionally, can you indicate how many rows of data should be calculated in that average? For instance 1 record I might want to reference 4 columns and another 12 column (historical)
