Supressing null values

[#1]

Hi Experts,

I am trying to supress the values by using supress when values is option,but not succeed.

I have the data  in straight table like below.

The data is same for all the fields except last field.

Now I want to supress the row where Components values as blank.but unable to succeed by using supress when values is option.

Can any one provide any sugesstions how we can supress that values from table???

Order ID	Date	Item	Status	Components
1	12/10/2014	A	Wait
1	12/10/2014	A	Wait	X
1	12/10/2014	A	Wait	Y
1	12/10/2014	A	Wait	Z

[Anonymous]

did you define "suppress Zero-Values" in the tab presentation as well?

[anbu1984]

What are your expressions in this table?

Only when all your expressions are null and "Suppress zero values" is set, then row will be suppressed

[anithashivalingappa]

Hi Swati,

If components is dimension then you can use "suppress when values is Null".

You can also try in presentation tab "suppress Zero-values" & "Suppress Missing" option.

[jonathandienst]

Hi

It will only suppress the row if all expressions return values that are null or zero. So the expressions should look like this:

     =If(Len([Components]) <> 0 And [Components] <> 0, <original expression>)

Which ensures that all the value are null if the Components value is null or zero.

HTH

Jonathan

[PrashantSangle]

Hi,

Take Component as Dimension and check "Supress When Value is null"

Regards

[tobias_klett]

Hi,

I guess you field in not NULL but empty.

Therfore enter the following set statement to your expression:

{<Components=-{''}>}

Regards Tobias