Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there,
How to have a chart show zero values and suppress null?
Here is what I have now if I uncheck Presentation -> suppress zero-values
Some dimensions have null value but other have zero.
How to truncate those dimensions with NULL and keep those with a value which could be zero or other value.
Help is very appreciated.
Thanks,
Josh
Hello Josh,
As a workaround, you can use SET NullInterpret = '-1'; statement in script and filter those records with -1 value.
Regards!
Rahul