Working with If Statement

Question

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

Ronal_bal · Answer

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..

MarqueeCrew · Answer

@Ronal_bal

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

cheers,

mark

Felipe_Ribeir0 · Answer

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.