Pull alternate field if first fields null 1

[TechUser23]

I have two fields

{data.ProviderName}
{data.resource}

Alot of the time, the enduser is not entering the ProviderName so its causing a blank field to display in my report. How can I program a formula to Pull from ProviderName first and if it null pull the Resource name?

 

[lbass]

Try:

if isnull({data.ProviderName}) then
{data.resource} else
{data.ProviderName}

-LB

 

[TechUser23]

lbass,

You are amazing ... THANKS A MILLION.