Ensuring 0 appears where "nothing" in a Report Cell

[Cognos_Jan2017]

We get some "blank" values among others where 0 is reported.

We tried the code below to check for Nulls or zero-length strings,
but "Blanks" can still appear.

The code tried (fully qualified path trimmed below to ABC) ...
Case
When (ABC is null) then 0
When (ABC = '') then 0
else
ABC
End

Other ways to show "Blanks" as 0?

TIA. Bob

[New_Guy]

Hi,
Did you try missing values in the Format properties?
Good luck
New guy

[Cognos_Jan2017]

Don't know how.

Is that the "Missing value characters"?

If correct, I entered 0 there ... but that didn't solve the problem.

Thank you, Bob

[Cognos_Jan2017]

CORRECTION ... I tried that in another file that had aggregates.

Apparently, entering 0 in "Missing value characters" DOES work.

Thank you New guy, Bob