Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two fields .
Deviation after sounding and Difference vs Log survey:
I want to write a code that if the difference between them is less than 2 then a new column will display yes against the value or else no.
if (Deviation after sounding) - (Difference vs Log survey) <=2 then (NEW COLUMN ) = "Correction done"
or else "Correction Not Done"
You can wirte this in the expression if you want to do it in the front end:
if(([Deviation after sounding] - [Difference vs Log survey]) <=2,'Correction Done','Correction Not Done')