Formula IF condition

[Ana_Miranda_2022]

I'm trying to replicate this formula from excel in alteryx, but I'm not getting it. Could anyone help me?

Formula: =IF(AND(D5<>"",G5<>""),"review","")

Below the data screen: I want to check if what is in the "365 days" (D5 in excel) column and what is in the "Current" (G5 in excel) column has value, if so, bring the word "review", otherwise bring nothing.

Thank you!

[DataNath]

What is the error that you are currently getting? And could you also clarify a bit - are you looking to see if the two fields are not null, are they bigger than 0? Or just looking to see if there's a value in them rather than null? Thanks!

[binuacs · Accepted solution]

@Ana_Miranda_2022 

IF(!isEmpty(D5) AND !isEmpty(G5),”review”,’’)

[Ana_Miranda_2022]

The second condition:  just looking to see if there's a value in them rather than null, if it is, should show word 'review'.

[DataNath]

Ok @Ana_Miranda_2022 that’s fairly straight forward then! Should just be able to use the following for your flag field:

if !isnull([365 Days]) and !isnull([Current]) then ‘Review’ else ‘<insert what you want to input if not review>’ endif

[DataNath]

Not sure if I’ve misread - if you want to put ‘review’ into your flag field when they ARE null then just remove the exclamation marks and use ‘OR’ instead of ‘AND’.

[grazitti_sapna]

Hi @Ana_Miranda_2022 ,

Try this

In case the field is null --- if (!IsNull([365 Days]) and !IsNull([Current]))  then "Review" else "" endif

In case the field is empty or blank --- if (!IsEmpty([365 Days]) and !IsEmpty([Current])) then "Review" else "" endif

Thanks!

[Ana_Miranda_2022]

Thanks. This formula worked for me!