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
Hi,
Did you try missing values in the Format properties?
Good luck
New guy
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
CORRECTION ... I tried that in another file that had aggregates.
Apparently, entering 0 in "Missing value characters" DOES work.
Thank you New guy, Bob