Filling NULL with data from different Column

mandrewcini

Hello,

I am sure this has been asked before.  I am a novice user and would like a simple solution here to complete my workflow.  I would like to replace NULL with my budget column for Current Period and QTD.  Attaching an image of my expected results.  Thank you for the assistance   

Capture.JPG

ShankerV

Hi @mandrewcini 

Please use the below formula.

IF IsNull([Current Period])
THEN [Current Period Budget]
ELSE [Current Period]
ENDIF

IF IsNull([QTD])
THEN [QTD Budget]
ELSE [QTD]
ENDIF

Many thanks

Shanker V