Supressing only 0 records ( NOT NULL)

[sai_adapa]

Hi,

I have a issue in my report .

In one of the report column I am getting 0, 1 and BLANK values.

Material Type	Value	CKF ( Count)
FERT	50	1
FERT	40	1
FERT	20	1
FERT	0	0
NON FERT	10
NON FERT	5
NON FERT	0

The issue is I need to only filter the 0 records.

Desired Output.

Material Type	Value	CKF ( Count)
FERT	50	1
FERT	40	1
FERT	20	1
NON FERT	10
NON FERT	5
NON FERT	0

But when I apply condition on 0 records BLANK records are also suppressing.

Please help to provide your thoughts.

Sai

[cornelia_lezoch · Accepted solution]

Hi Sai,

are you working together with the guy who wrote this thread? Because it´s exactly the same question.

http://scn.sap.com/thread/3732646

As I said there, you need to have a counter which is counting existing data records.

You can do it whith exception aggregation.

regards

Cornelia

[Loed]

Hi Sai,

That's the normal behavior of query designer because BLANK values are considered as ZERO for keyfigures..

You may refer in my last three (3) replies in this thread, you have similar situation:

Regards,

Loed

[Former Member]

Did you create a condition or use suppresion from Query properties ?

Query properties should do what you need.

Query Designer / Properties / Rows&Column --> Supress Zero