Conditional Average with Variable Conditions
I've got a database in FMP11 where a user can enter data on biochemical assays into a portal. The data includes the type of assay it is, the trial number, and the results (also a number). I want a portal on that layout to show the averages of the results for assays of the same type, but as far as I can tell there is no average-if function. Also, a complication is that the different types of assays are not set– that is, the user can add a completely new type of assays by typing its name into the "assay type" field.
How would I go about setting this up? Thanks in advance.