How to find maximum value for a field

Business Central/NAV Developers Forum
1

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…

2

Hi Bavani,

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

3

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.

4

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

5

Im getting the same error

6

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;