MAX Value

mrigya · 2008-09-26

Hi All
Can anybody tell me is there is any function like MAX in NAV, which can get the maximum value in the field of type decimal or integer.

Thanks and Regards
Mrigya Matoo

garak · 2008-09-26

do you need a function which returns the highest value are possible in an integer field or decimal field?

like decimal = range between -999.999.999.999.999,99 - 999.999.999.999.999,99
like integer = range between -2147483647 - 2147483647

or the highest value are stored in your recs like under sql?

select MAX(Field) from Table Where Condition

mrigya · 2008-09-26

I m not working on SQL ..i want this thing to be done in Navision.

idiot · 2008-09-26

Where do you need this? Report? Forms? Table?

leugim · 2008-09-26

hi
there is not a specific function to return the maximum value of a field/data type, i think
check the data type you are using to know the range
if you want to know the max value in a field from a table, create a new key using your field and change your sorting using that key...

regards

kine · 2008-09-26

for integer you can use the integer table... for decimal, there is no way.

garak · 2008-09-26

In my meaning the integer Table has only stored the data between - 1000000000 and 1000000000

garak · 2008-09-26

kine wrote:

for integer you can use the integer table

In my opinion the integer Table has only stored the data between - 1000000000 and 1000000000

kine · 2008-09-26

garak wrote:

kine wrote:

for integer you can use the integer table

In my opinion the integer Table has only stored the data between - 1000000000 and 1000000000

:oops:

Thanks, never noticed that, never needed it... 8)

Savatage · 2008-09-26

Flowfields have a MAX method - but it will kill performance if the table is big

Couldn't you make your own function to loop thru the records
if vMaxValue < "your integer"
then vMAxValue := "Your Integer";

at the end vMaxValue should have the largest #? :-k

Dev · 2008-10-01

No... Idea!!!

Dev · 2008-10-07

Hi....u try this...i wish it worked...

Documentation()

Sales Line - OnPreDataItem()
MaxAmt := 0;

Sales Line - OnAfterGetRecord()

REPEAT
Amt := "Sales Line"."Line Amount";
IF Amt > MaxAmt THEN
MaxAmt := Amt
UNTIL "Sales Line".NEXT = 0;

Sales Line - OnPostDataItem()

mrigya · 2008-10-07

Thanks a Ton,its working Fine.

Savatage · 2008-10-07

That solution looks familiar

glad it works!

Savatage wrote:

Couldn't you make your own function to loop thru the records
if vMaxValue < "your integer"
then vMAxValue := "Your Integer";
at the end vMaxValue should have the largest #? :-k

Howdy, Stranger!

Quick Links

Categories

MAX Value

Answers