Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

If Statement

Kinetic_analytics
11 - Bolide

Hello:

 

How to convert this following IF logic:

 

=IF (Date AQL Compliant>0,( Next Review Date- Date AQL Compliant)/365,0)

 

Thanks

10 REPLIES 10
PhilipMannering
16 - Nebula
16 - Nebula

Something like this should work,

 

IIF([Date AQL Compliant]>0, ( [Next Review Date] - [Date AQL Compliant] )/365, 0)
messi007
15 - Aurora
15 - Aurora

@Kinetic_analytics,

 

IF [Date AQL Compliant]>0

THEN ( ( [Next Review Date]- [Date AQL Compliant])/365)

ELSE

0

ENDIF

 

Below how you can use the formula with If statement :

 

messi007_0-1640015133660.png

 

Regards,

Kinetic_analytics
11 - Bolide

Getting the error Malformed if statement.

messi007
15 - Aurora
15 - Aurora

@Kinetic_analytics,

 

Please share sample data with the formula, it will help to investigate.

 

Regards,

Kinetic_analytics
11 - Bolide

Unknown Variable "IF"

PhilipMannering
16 - Nebula
16 - Nebula

Hi @Kinetic_analytics 

 

Either of our solutions should work. Like @messi007 says, if you share just one row of data we can provide something that works.

Kinetic_analytics
11 - Bolide

here yo go

messi007
15 - Aurora
15 - Aurora

@Kinetic_analytics,

 

Below the updated workflow :

You have to correct the date format in row 5.

 

messi007_0-1640018938086.png

 

Regards,

Kinetic_analytics
11 - Bolide

Thanks. it works. Great learning.. Appreciate your help on my learning journey.

Labels