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…

Please help…

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…

Please help…

Hi Bavani,

what have you tried so ve you tried so far? Are you getting some error message?

Hi David,

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.

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

IF View = View::Minimum THEN

SETFILTER(“Result”,MinValue…MaxValue);

“Row Result”:=GETRANGEMIN(Result);

IF View = View::Maximum THEN

SETFILTER(“Result”,MinValue…MaxValue);

“Row Result”:=GETRANGEMAX(Result);

Just try it

Im getting the same error

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;