Hello:
How to convert this following IF logic:
=IF (Date AQL Compliant>0,( Next Review Date- Date AQL Compliant)/365,0)
Thanks
Solved! Go to Solution.
Something like this should work,
IIF([Date AQL Compliant]>0, ( [Next Review Date] - [Date AQL Compliant] )/365, 0)
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,
Getting the error Malformed if statement.
Please share sample data with the formula, it will help to investigate.
Regards,
Unknown Variable "IF"
Either of our solutions should work. Like @messi007 says, if you share just one row of data we can provide something that works.
Below the updated workflow :
You have to correct the date format in row 5.
Regards,
Thanks. it works. Great learning.. Appreciate your help on my learning journey.