IF [Field_1] > [Field_2] then... in the script

[#1]

Hi,

How i can compare the value of two field in the script,

i want to do : IF( [Field_1] > [Field_2] then 'Value' ) as new_field.

Thanks

[marcus_sommer · Accepted solution]

Then you could use:

IF([Field_1] > [Field_2], 'Value', 'SomeOtherValue' ) as new_field

- Marcus

[raghvendrasingh]

Please try this one:

IF( [Field_1] > [Field_2] , 'Value' )  as new_field

[#4]

Thanks a lot Guys.