Formula for: If 1 field isnull then show 2 fields

[former_member406941]

Hello!

I'm trying to write a formula that would show two fields, next to each other, if 1 field is null. Something like this (though this doesn't work)

"If isnull ({field 1})

then ({field 2} and {field 3})

else {field 1}

Can this be done? Thanks! Rich

[abhilash_kumar · Accepted solution]

Hi Rich,

If Field1 is a string field, try:

If isNull({Field 1}) OR {Field 1} = '' then
{Field 2} & " " & {Field 3}
Else {Field 1}

-Abhilash