Skip to Content
author's profile photo Former Member
Former Member

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?


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 06:21 AM


    In the structure where you display the key figures, go to properties, there is a option Zero suppression for structure elements, kindly check that and try the result.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 10, 2008 at 06:47 AM

    Hi Kiran,

    Let us try to acheive this using a small logic.

    Try creating a calculatedd keyfigure.

    Then in the formula editor using the conditon If Value=0 keyfigure value= *

    here * means assign some different value to that KF.

    Now in report restrict that KF by that * Value this vl not filter blank value i thin.

    Please let me know whether this logic helped u or not.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      Hi Karan

      I had the same problem (see text below) and just solved it myself. I used the replacement routine in the communication structure in the update rules for the cube. That didn't work, the system made no difference between blank and zeros.

      I changed that and used the routine in the transfer structure. That way it works now.

      Hope this helps you a little bit.




      Hi Kiran

      I encounter exactly the same problem at the moment. Could you solve this mystery in the meantime?

      I tried different key figure types: DEC and INT4 didn't work.

      Thanks for updating me on this.


      Edited by: Michael Egger on Apr 11, 2008 11:23 AM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.