Hide empty records

[Luke_Killer_IT]

Hello, I have this problem I need to hide empty records I created this command 

if(Sum(MMT_MRPAccount.DemandQty)>0 ,Sum(MMT_MRPAccount.DemandQty),' ')

[anat]

click on "Suppress when value is null"

[Luke_Killer_IT]

I am not using imported data in this table, I am using chart functions and therefore I have problems with hiding unwanted empty data.

[anat]

go to presentation tab ,suppress null value

[SadlerS]

Then click Home > Find & Select > Go To Special, see screenshot: And in the Go To Special dialog, select Blanks option, and then click OK button. All of the blank cells in the selection have been selected, see screenshot.

TellPopeyes.com

[Prasad_Kanse]

1)  dimension Tab > Suppress When value is Null

2) Presentation Tab > Suppress Zero - Values

But as I can see you are using multiple expressions. Other expressions giving you the extra rows in a result.  So, you have to use set analysis expression for Bedaft i.e. {< Field_name = {" sum(expression) >1 "}    > }.

[Anonymous · Accepted solution]

Perhaps changing the expression to:

if(sum(MMT_MRPAccount.DemandQty) >0, sum(MMT_MRPAccount.DemandQty), Null() )

and then as others suggested change the setting to suppress null values.

With your current expression the 0 or less values are a string of spaces and are not nulls.

HTH,

John