# Determine highest serial number

This topic is 4400 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

What is the easiest way to compute the highest serial number in a column, in FM10?

The serial numbers are of the form P-000002 - that is, fixed-width integer with alpha prefix (thus unusable by the max() function).

If sort / goto record is the only way, so be it - just thought there might be a better way.

Thanks,

Chap

##### Share on other sites

Without going into detail you could strip out the "P-" and use the remainder in the MAX function.

##### Share on other sites

...thus unusable by the max() function).

Hi

what about using the Min ( ) function ?

Try this calculation:

"P-" & Right ( "000000" & Abs ( Min ( YourSerial ) ) ; 6 )

Note that this will work ONLY if your serial is always in the format: P-nnnnnn

##### Share on other sites

Min ( YourSerial )

I don't think that's a valid expression (unless YourSerial is a repeating field).

My impression is that OP wants the highest serial number in a found set, and cannot use a summary field for this. We need to know if the prefix character is always a single "P".

##### Share on other sites

I don't think that's a valid expression (unless YourSerial is a repeating field).

My impression is that OP wants the highest serial number in a found set, and cannot use a summary field for this. We need to know if the prefix character is always a single "P".

YourSerial was an abbreviation for a self-related field, commonly used for the Summary functions, but you are right... it is better to specify:

"P-" & Right ( "000000" & Abs ( Min ( CartesianSelfJoin::YourSerial ) ) ; 6 )

He said that cannot use the Max( ) function, so I think that he needs the max from all the records.

##### Share on other sites

Well. if you have a x self-join, you could sort it by the serial, descending. Then

SelfJoin::YourSerial

##### Share on other sites

No warning that calculating keys can be error-prone, guys? Seems like that's what the OP is doing..

##### Share on other sites

This topic is 4400 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account