I want to know how to get the average of a group rather than using the aggregate: Below is the screen of the shot. 1st table show correct average which where a variable is an aggregate. 2nd table uses the same variable which is an aggregator and therefore its averaging of both Amount (ppm). Version C.01.07. SR2. ECM 3.4.1.Thank you for your support.