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.
Solved! Go to Solution.
Hi @CherylH
Something like this
IIF(IsNull([BP Billing #]) AND ISNull([lDPSGCode]),[lDPSGCode],[BP Billing #])
Happy to help 🙂 @CherylH
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any other issues 🙂