Tonumber error

moshood

Hi All

Im trying to write: if the date column is empty/null then 0 otherwise 1 but this error keeps popping up. 

it will only read the formula if the the 0 and 1 are in brackets but i then get the tonumber error. 

Can you let me know your views on what i am doing wrong

Thanks again 

Capture.PNG

bpatel

hi @moshood,

try this if isnull([Lease start date]) then 0 else 1 endif

hope this helps!