AnsweredAssumed Answered

Conditional Average with Variable Conditions

Question asked by Modulo on Jun 25, 2010
Latest reply on Jun 29, 2010 by Modulo


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.