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?
Try an expression like this:
if {object} is null
then 0
else {object}