Pick Min value from 2 fields

[Genty]

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

[Thableaus]

Hi @Genty 

There's a Min function in alteryx.

Use Formula Tool.

Min(Field1, Field2)

Cheers,

[Genty]

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

[Thableaus · Accepted solution]

@Genty 

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,

[Genty]

yea had to wrong data type set on one of the fields. now resolved thank you