how to show missing data or null values in if statement

Looker Q&A Looker
1

I’m creating a custom dimension on looker and need to type if statement but in the if statement I am not sure how to show my null value or values that are not in data ?

I want true to be 1 , null and false to be 0

any successions ?

thanks in advance