If Statement

[Kinetic_analytics]

Hello:

How to convert this following IF logic:

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

Thanks

[PhilipMannering]

Something like this should work,

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

[messi007]

@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 :

Regards,

[Kinetic_analytics]

Getting the error Malformed if statement.

[messi007]

@Kinetic_analytics,

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

Regards,

[Kinetic_analytics]

Unknown Variable "IF"

[PhilipMannering]

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]

here yo go

[messi007 · Accepted solution]

@Kinetic_analytics,

Below the updated workflow :

You have to correct the date format in row 5.

Regards,

[Kinetic_analytics]

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