topic condition with 3 Fields in Management & Governance

condition with 3 Fields

zied_ahmed1 — Thu, 20 Apr 2017 09:17:20 GMT

Hello, I have 3 fields field1 field 2 and field3

I want when :

1/ field 1 > field 2 field3 i display 1

2/ Field2> Field 1 >Field3 I display 2

3/Field3> Field2 >Field1 I display 3

If we have just 2 Fields we will do : if (Field1>Field2,1,2)

Regards

Anonymous — Thu, 20 Apr 2017 09:24:53 GMT

if (Field1>Field2 and Field2>Field3,1,(if(field2>field1 and Field1>field3,2,(IF(Field3>Field2 and Field2>field1,3)))))??

zied_ahmed1 — Thu, 20 Apr 2017 09:38:35 GMT

Just we Need 1>2 and 1>3 etc...

Anonymous — Thu, 20 Apr 2017 09:41:06 GMT

Didnt get you Zied.

You can change the condition to

if (Field1>Field2 and Field1>Field3,1,(if(field2>field1 and field2>field3,2,(IF(Field3>Field2 and Field3>field1,3))))).

But both are same. Transtive property