columns with text and numbers

[chiragpatel_1]

Hi,

Im trying to put a formula in which mimics the excel formula below

=IF(OR(AK2="",AK2<=1),0,1)

AK being the column called 'Report notes', this column has text, numbers and empty cells and has the above formula applied in new column ('rate') of course which works fine in excel but in Alteryx I'm finding it difficult to make it work with the below, the output of below is all nulls.

IF IsEmpty([Report Notes]) OR ToNumber([Report Notes]) <= 1 then 0 else 1 endif

Report notes column is in v_string format fyi, as having it as int32 gets rid of the text.

Have tried all kinds of things with above but no luck, any help will be great.

Thank you

[chiragpatel_1]

This is creative will keep it for future . thank you