add is not null

[CherylH]

Hi,

Need a little help. Need to add if DPSGCode is null to formula below. 

     iIF(IsNull([BP Billing #]) AND [lDPSGCode],[lDPSGCode],[BP Billing #])

Thanks in advance for the assistance.

[atcodedog05 · Accepted solution]

Hi @CherylH 

Something like this

IIF(IsNull([BP Billing #]) AND ISNull([lDPSGCode]),[lDPSGCode],[BP Billing #])

[atcodedog05]

Happy to help 🙂 @CherylH 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂