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

[amruthas2]

Hi @Kinetic_analytics 

IF [Date AQL Compliant] >0
THEN ([Next Review Date]- [Date AQL Compliant])/365
ELSE 0
ENDIF

You can see this formula