AnsweredAssumed Answered

Selective Max and Min Values

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


Selective Max and Min Values



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,