Newbie Questions

Re: Max Function question

Derrick — Fri, 02 Oct 2009 13:58:05 GMT

max(field1|field2|field3) works like a charm.

Thanks so much, Alec & Qazi.

Re: Max Function question

Alec Pojidaev — Fri, 02 Oct 2009 13:14:36 GMT

Qazi Anis:

try max(field1,max(field2,max(field3,...)))

Max function doesn't work that way.

The right expession: max(field1|field2|field3)

Re: Max Function question

Qazi Anis — Fri, 02 Oct 2009 03:39:02 GMT

try max(field1,max(field2,max(field3,...)))

Max Function question

Derrick — Thu, 01 Oct 2009 15:50:52 GMT

Hello,

I have several Text Boxes with Integer data type that allow user to input the value. I would like to calculate the maximum value of these fields by using the Max() function and assign it to a new field. I can't get the Max() function to work properly. It doesn't allow multiple fields as input arguments. I also combined all the fields into a single group and use it in the formula but it doesn't work either and keep getting a "NaN" in the resulting field. Thanks for any help!

Derrick

Example:

Field1 = 2, Field2 = 3 , Field3 = 5, Field4 = 2, Field5 = 8 , Field6 = 5

Answer: MaxField = 8