cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hi,

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?

Regards

Steve

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Thanks

Former Member
0 Kudos

Hi,

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.

Regards

Steve