Skip to Content
Former Member
Apr 09, 2008 at 10:58 PM

Differentiate blank and zero values



I have a query with a few keyfigures. My requirement is to hide some of the keyfigures based on the value entered in the variable. Everything is working fine. But I am facing a strange problem. I want to suppress only the keyfigures which have a zero in them. But the system is hiding even the columns which are blank. For some reason or setting, the system is not differentiating between a blank value and a zero value. Can someone tell me how to suppress only zero columns and not the blank values?