Query doesn't show 0 at the beginning of the figures..

[Former Member]

Hi Experts,

I run a report made in Query Designer, and get some figures differently as it is stored in the tables. For some characterictics I do not get the "0"-s displayed at the beginning of the figure. (Yes, these are characteristics and NOT key figures..)

Here you can find a picture about the problem: http://kepfeltoltes.hu/100727/aaa_www.kepfeltoltes.hu_.png.

"Product code" is showing without 0, "product group" with 0, although both are stored with 0 in the tables.

What can be the cause of that. Any idea?

Thanks in advance..

[Former Member]

It by default ignores the Zero. You can use a workbook for achieving this easily.

-Vikram

[Former Member]

Hi,

thanks for your answer. Then why doesn't ignore it consequently? I opened this report directly from QD, so used the standard web template (0analysis_pattern).

Thanks..

[Former Member]

Request you to please elaborate your question.

-Vikram