calc to get greatest value

[grumbachr]

Please point me in the right direction. I need to get the highest value from 4 different fields in the same record. I'm not ever sure where to start.

In my head I keep thinking its going to have to be done with a Let Function but I'm not very good with Let Functions as of yet maybe I need to get better.

Any suggestions are greatly appreciated.

[Delta Tango]

Hey,

that's what the Max function is for.

Take a look at this sample file.

MaxFunction.fp7.zip

[grumbachr]

Thanks so much. Thats a lot easier than I expected. I wonder if i've been staring at FileMaker to much since that was so easy and i missed it.

[Delta Tango]

don't worry, it goes like that for all of us!!! i feel the same way still sometimes.

There's also a min() function which works exactly the opposite.

Edited October 3, 2007 by Guest