EXAMPLE 1: Display constituent and spouse name, if the spouse exists. The following formula should display the constituent and spouses names when the spouse is not deceased. Otherwise it will just display the constituent name.

If {GfCnSpSpBio.GfCnSpSpBio_Deceased} = true then ({GfCnBio.GfCnBio_First_Name}
else {GfCnBio.GfCnBio_First_Name} + " and " + {GfCnSpSpBio.GfCnSpSpBio_First_Name}

The formula will return a blank value if the Deceased field is null (could mean there is no spouse). Therefore, we need to check for null values in the formula:

if isNull({GfCnSpSpBio.GfCnSpSpBio_Deceased}) then {GfCnBio.GfCnBio_First_Name}
else if {GfCnSpSpBio.
GfCnSpSpBio_Deceased} = true then ({GfCnBio.GfCnBio_First_Name}
else {GfCnBio.GfCnBio_First_Name} + " and " + {GfCnSpSpBio.GfCnSpSpBio_First_Name}



EXAMPLE 2: Display the addressee field unless the record is marked as anonymous. The following formula should display the Addressee field when the Anonymous field is not True.

if {ANONYMOUS.EN_US} = True then "Anonymous" else {ADDRESSEE.EN_US}

The reason the formula is blank is because the Anonymous field is sometimes Null. Check for the Null value as follows:

if isNull({ANONYMOUS.EN_US}) then {ADDRESSEE.EN_US}
else if {ANONYMOUS.EN_US} = True then "Anonymous"
else {ADDRESSEE.EN_US}




EXAMPLE 3: A formula is summing multiple fields together. When one of the fields is null, the entire formula will be blank.

{#FY11Gifts} + {#FY12Gifts} + {#FY13Gifts}

Add a check for null values to the formula:

(if isNull({#FY11Gifts}) then 0 else {#FY11Gifts})  + (if isNull({#FY12Gifts}) then 0 else {#FY12Gifts}) + (if isNull({#FY13Gifts}) then 0 else {#FY13Gifts})



EXAMPLE 4: The fields are in a textbox. If the field is located in a Text Object with other fields/formulas, then check for the Suppress Embedded Field Blank Lines formatting option on the Common tab. If this checkbox is marked then use a formula logic similar to below:

if not(isNull({FIELD.EN_US})) and {FIELD.EN_US} <> "" then {FIELD.EN_US} else " "