I have a problem with missing symbol in QV chart. I use formula "Count(distinct field_name) " in my chart expression and for those cells wich are missing, I would like to see 0 (as number). Is it possible to achieve? I tried methods IF(IsNULL(Count(distinct field_name)), 0, Count(distinct field_name)), but this does not work.
But I don't know why what you said wouldn't work. Well, unless you're using 64-bit, which has issues with isnull(). If that's the problem, use len(...)>0.
Another option might be to make your null symbol be 0 and right justify it in the cell.
