How to find min,max,mean for a field

bavani_uma

Hi,

In the form i have option global variable with option minimum,maximum,Average and a textbox to dispaly a result.

Based on the option it should calculate the min,max,mean of the RESULT field and display it in the textbox..

In the OnValidate trigger of the option textbox i wrote the following code


IF View = View::Minimum THEN
SETFILTER(Result,'%1',Result);
"Row Result":=GETRANGEMIN(Result);
IF View = View::Maximum THEN
SETFILTER(Result,'%1',Result);
"Row Result":=GETRANGEMAX(Result);


But its showing me the error:

Please specify a filter for the result field in the Table.

Then how should i do for mean... Is there any default function availabe


Please help..

kine

GETRANGEMAX and GETRANGEMIN are returning MAX and MIN of the filter range applied to the field, not values from the fields itself.

You can use MAX and MIN functions on some FlowField to calc the value, but it seems that best will be to loop through the values and calc all three values yourself.

Alex_Chow

On the method of the flowfield, there are min, max, and average calculations.

bavani_uma

I tried the following code but im not getting the output

IF View = View::Minimum THEN
BEGIN
glbrecrules.RESET;
IF glbrecrules.FIND('-') THEN BEGIN
"Row Result" := glbrecrules.Result;
REPEAT
IF "Row Result" > glbrecrules.Result THEN
"Row Result" :=glbrecrules.Result;
UNTIL glbrecrules.NEXT = 0;
END;
// "Row Result" := glbrecrules.Result;
END;