Skip to Content
Jan 15, 2021 at 06:21 AM

Formula with a null value


Hi in my sub report I have a formula that looks at a number value only three for a status quite simple really so I have created the below code but when the value is null that is no number it displays open as a value. There is no vlaue and it highlights Open as a result and have no idea why this is the case. The only way I have been able to hide it is to have change the font colour to white?

if {number.Complete} = 1 then "Complete" else
 if {number.Complete} = 0 then "Open" else
 if {number.Complete} = 2 then "Skipped" else
if isnull ({number.Complete}) then "66" /for example