Calculation to find max value in field

[Redbeard]

I am trying to come up with a calculation that will display the highest number used in a field for all records, regardless if they are in the found set or not.

[cjaeger]

set up a self-join relation

x=max(selfjoin::y).

The self-join should be based on a calculation thatis true for all records, i.e. a calc z=1.

so the relation is myfile, z <-> myfile, z.