AnsweredAssumed Answered

Selective Max and Min Values

Question asked by JonathanPhillips on Dec 11, 2014
Latest reply on Dec 13, 2014 by JonathanPhillips

Title

Selective Max and Min Values

Post

Hi,

I am trying to use a calculation to find the MIN and MAX values from a certain field. But I only want to use the values in that field that are present when another field has a specific value.

Table 1: So, in one field I have a value list, where I pick a shop: Grocery Store, Bakers etc. Then another value list field with products: Apple, Pear, Orange etc. Then I have a number field where I insert the price.

Table2: Now, in the Grocery Store table, I want to create a field that will tell me the maximum price paid for an apple. But how do I create a calculation that will only select the values in the price field when the product field says "Apple"? 

Any help with this would be greatly appreciated,

Jonathan

Outcomes