Show 'INVALID' if null

[RunForrestRun]

Hi, I have a submission form with 2 virtual fields and wants to show 'INVALID' if Virtual 1 is null or blank. I have this formula but it shows blank instead of INVALID

CASE WHEN [@cbParamVirtual1] = ""
THEN 'INVALID'
ELSE [@cbParamVirtual1]
END

 

What I am doing wrong? 

[Flowers4Algernon]

Hi @RunForrestRun, you may want to try this formula instead:

 CASE WHEN '[@cbParamVirtual1]' = ""
THEN 'INVALID'
ELSE '[@cbParamVirtual1]'
END

Please note that I have wrapped your virtual field into single quotes. 

[IamNatoyThatLovesYou]

Hi Everyone, you may find their HowTo Documentation regarding function references that can be used helpful. You may check it here.