How to find Min/Max

[jmriddic]

Hi all,

I have 4 fields called presten1,presten2,presten3, and presten4. Since they denote a smilar type value the user wants to find the overall min/max for the fields as a whole.I am having a lot of trouble even trying to come up with a formula to compare each one with another in the instance I am trying to find the minimum.My report is totally written in the report trailer if that helps. Can someone offer a suggestion on how to do this? Thanks.

 

[lupins46]

You just need a formula field at the end of your report.

This one does the minimum.

numbervar mymin;
mymin:=minimum({mytable.presten1});
if mymin>minimum({mytable.presten2}) then
mymin:=minimum({mytable.presten2});
if mymin>minimum({mytable.presten3})then
mymin:=minimum({mytable.presten3});
if mymin>minimum({mytable.presten1})then
mymin:=minimum({mytable.presten4});
mymin

 

[bdreed35]

How about just this in a formula:

minimum([minimum({mytable.presten1}),minimum({mytable.presten2}),minimum({mytable.presten3}),minimum({mytable.presten4})])

~Brian