formula help needed

Printed From: Crystal Reports Book — Forum Name: Technical Questions

Posted By: ldodge — 29 Nov 2016 at 5:10am

My current formula doesn't take nulls or undocumented into account:
({PERINATAL_DELIVERY_MATERNAL.episiotomy}) <> "None"

How can I rewrite the formula to account for nulls?

Posted By: DBlank — 29 Nov 2016 at 8:28am

in the formula editor flip the option to 'use default values for nulls'

NOT isnull({PERINATAL_DELIVERY_MATERNAL.episiotomy})
OR ({PERINATAL_DELIVERY_MATERNAL.episiotomy}) <> "None"