Displaying Blanks instead of '0'

[Former Member]

Hi

I have a keyfigure which is QTY. When i execute a query, for some articles the value is showing as "0EA" and for some other articles its showing BLANK.

I have gone thrus some discussions in the forums to displayzeros. In query properties>display value>display zeros--> defaulted to "0" but still this doenst work.

In RSCUSTV4, i set to "0" that also doenst work.

1. What might be the reason? Its showing 0 QTY for some articles and BLANK for others.

2. How can i fix this?

Thanks

Annie

[Former Member · Accepted solution]

Hi Annie,

It is showing blank, may because for that particular combination, there was no quantity value (not even 0) in the data target and whenever it displays 0EA, that means an entry has come with a 0 value and UoM EA.

So While populating your data target make sure that whenever data is not there for a combination, it is populated as '0'

In the query properties there is an option, of displaying Blanks as '0'.. You can use that too.

Regards,

Godhuli

Edited by: Godhuli Pandey on Apr 30, 2009 12:57 PM

[Former Member · Accepted solution]

Hi

Thanks for the replies..

In query properties, i dont see any option of displaying blanks as '0'

In "Value Display" tab. I have only the option of dispalying the 0's as something else but not for blanks.

Is there any way of displaying blanks as some defalut in the report?

REgards

Annie

[Former Member · Accepted solution]

Hi Annie,

Try in TX: "RSCUSTV4"

opposite doesnt exits give' 0'.

Thanks,

Vijay.

[Former Member]

RSCUSTV4 applies to all the queries. I just added the keyfigure with '0'. Thanks

[Former Member]

Hi Annie,

Try this......

In query properties-->display >zero value display----->display zeros

It may help you.

Thanks,

Vijay.

[Former Member]

Annie,

I think infoprovider(cube/ods) contains some records with Zero value some with blank.

Try to compress cube with "delete Zero record rows". If all keyfigure values are zero, record will be deleted on compression.

Srini