AnsweredAssumed Answered

Conditional Average with Variable Conditions

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

Title

Conditional Average with Variable Conditions

Post

Hello,

 

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.

Outcomes