Skip to Content
Oct 10, 2018 at 11:03 PM

crosstab null x zeroes


Incredible how difficult is to find out a solution to differentiate ZEROES and NULLS!

I saw something like this:


Hi Leo,

Right-click one of the cells in the Summary fields > Select Format field > Common tab > Click on the formula button beside 'Display String' and use this code:

if currentfieldvalue = 0 then "N/A"





But I can´t say 0 is the same as null !!!

Some record sets return values to populate a crosstable that
a) Sometimes they are regular numbers ---ok!

b) Sometimes they are 0 (read from database) and

c) Sometimes there is no data for that place!

How would we differntiate (b) and (c), since I must show 0 (zero) because it is a regular value from my database.

And I don´t want missed values to be shown as "0" too (because they are NOT zero, they simply inexist!)

Any Idea?