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

Design Studio 1.5 display of 0 (zero) values in crosstab


I face some strange issue regarding the display of 0-values.

In my query I have a structure with formulas. For some selections this query delivers '0'.

When I display the query in a Crosstab in Design Studio, the '0' values are not displayed.

I already tried to change the setting for displaying '0' in the query and also in the initial view of the data source. Without success.

Basically '0' values are displayed.

It seems to be a problem, when all values of a row are '0'.

The row is also not suppressed. (the unit 015530 is still displayed)

If the result set would be empty, it would be displayed as followed.

Does anyone face the same problem?

Or is there some solution for this behaviour?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2015 at 06:09 PM

    Hi Steve

    This looks weird, for the set of selection that give you zero in all the cells, can you share your BEx output for the same set of selections. The crosstab in Design Studio will generally render your initial view of the datasource which is nothing but the BEx initial output.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      the first picture is the BEx query (web output).

      The structure element (in the row) is a formula that simply divides 2 selections. (with some NODIV() around)

      In the columns ACT and BP are selections (Actual and Plan). The %-column is a formula again to calculate the deviation.



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.