Working with If Statement

[Ronal_bal]

Hi,

I need to compare the values in 2 fields and a create a flag based on the following condition

if [A] >= [B] THEN 1 ELSE 0 ENDIF receiving following error

In the below example, I need to flag when the value in field A is greater than or equal to Field B

[BS_THE_ANALYST]

Are your columns/fields named [A] and [B]? because your logic is correct! if [A] >= [B] THEN 1 ELSE 0 ENDIF

[BS_THE_ANALYST]

@Ronal_bal workflow attached

[Felipe_Ribeir0]

Hi @Ronal_bal 

Are you creating a new column with the 'Add a column option'?

I get errors similars to the one that you got when this field is not selected.

[MarqueeCrew]

@Ronal_bal 

Unfortunately you did not label the name of this field.  Give it a name and you'll be golden. 

cheers,

 mark

[Ronal_bal]

There was an issue with field type as one of the field type was string. I converted it to int and its working fine now..