AnsweredAssumed Answered

Using ExecuteSQL to Get Max() Matching 2 Groups

Question asked by SimonLiu on Nov 10, 2018
Latest reply on Nov 14, 2018 by beverly

Greeting and appreciation in advance

I have a table like this:

Product
TypePrice
Product 1A1000
Product 2A300
Product 3B200
Product 1B500
Product 1A999

 

I need to get the highest price for the record matching both Product and Type, and put the results in a new field.

 

Like this:

ProductTypePriceField4
Product 1A10001000
Product 2A300300
Product 2B200200
Product 1B500500
Product 1A9991000

 

I assume that I should make Field4 a calculation using the ExecuteSQL function, however failed after many tries.

 

Please kindly help me solving this.

Many thanks!

Outcomes