IF Formula Help needed - NULLs? 1

[Jeffs23]

My current formula:

IF {aaUDS7;1.PrenatalPatient} = 1 AND {aaUDS7;1.Age} < 15 then 1 else 0

In my dataset, PrenatalPatient is NULL on all my patients. In my report, I am expecting to see a 0; however I am not getting any value. Should I be evaluating for my NULLs somehow?

 

[briangriffin]

Try testing for null values first:

if isnull({aaUDS7;1.PrenatalPatient}) then 0
else
IF {aaUDS7;1.PrenatalPatient} = 1 AND {aaUDS7;1.Age} < 15 then 1
else 0

 

[Jeffs23]

Thank you kindly!