Pick Min value from 2 fields

Hi all,

I am trying to use the formula tool to pick the minimum value over two fields.

E.G [Field 1 =3] [Field 2 = 7] = 3

Any help how I could do this?

Regards

Datasets

Accepted answers

This is a numeric function.

You might need to do the ToNumber Conversion if your fields are string types.

Min(ToNumber(Field1), ToNumber(Field2))

Cheers,

There's a Min function in alteryx.

Use Formula Tool.

Min(Field1, Field2)

Cheers,

Not sure how I missed that (facepalm), I am now however getting a "Invalid type in operator <." error 😞