Hello everyone,

I'm new to Cognos Analytics. I'm trying to build a CrossTab. The viz gives me (no value) for all NULL values. I would like to edit this to either make it '0' or Blank. Could you please help me on this?

Additionally, I tried the following methods but it didn't work out.

-> CASE
   WHEN Quantity = '' THEN '0'
    ELSE Quantity END
-> coalesce (trim ( both, Quantity),'0')

Let me know your thoughts.


------------------------------
Sri
------------------------------

#CognosAnalyticswithWatson

Hello,

You can try the following,

Try the "clean" functionality as mentioned at this link: https://www.ibm.com/mysupport/s/question/0D55000005cRQPkCAO/no-value-and-not-0-in-dashboard-with-crosstab?language=en_US

The video mentioned at that link is actually located here: https://www.youtube.com/watch?v=plosFS5cxHQ



------------------------------
Steve Templeton
------------------------------

Hello Sukasri,

have you tried with the format option for the Crosstab cells?
You can try putting a zero here.

------------------------------
Alex Santamarta
------------------------------