running count or count does not work

[Dipika Dabhakdar]

Hello Cognos Expert,

I want to display a value 0 for an query item when there is absolutely no record for that field.

So far I tried running count and count function to check to see if there is any record, but none of them works.

can anyone help in solving this issue?

[bus_pass_man]

Try an expression like this:

if {object} is null
then 0
else {object}