7 Replies Latest reply: May 14, 2012 12:14 PM by Raj vadde

# Hide a table when all values are zero or blank

I have several straight tables. I only want to display those tables with values I want to hide all the tables with no value or blanks.

The value in the tables are based on Fields selected in the Multi Box.

How can I do this? Thanks in advance for your help.

• ###### Hide a table when all values are zero or blank

Try using the Calculation Condition on the General Tab.  It will only generate based on the conditions you set.  It can also display a message indicating that the calculation conditions have not been met

• ###### Hide a table when all values are zero or blank

Or better yet, there is also a conditional show in the Layout Section of the properties.

• ###### Re: Hide a table when all values are zero or blank

Can you tell me how to write the condition to hide the table?

In my Multi Box, I have 4 population category, if category = orange then I would like the table to be hidden.

Thanks.

• ###### Hide a table when all values are zero or blank

It's a simple Boolean formula.  So in the Show Condition just type

category<>orange

However, what if more than one category selection is made i.e. green and orange are both selected?  If you want to hide the table if orange is contained in the category selections then you will need

INDEX(GetFieldSelections(category),'orange')=0

But what if orange is an associated value i.e. some other selection is made that is associated to orange?  If you want to hide the table in this case you will need

INDEX(Concat(DISTINCT category,','),'orange')=0

Hope this helps,

Jason

• ###### Hide a table when all values are zero or blank

Jason,

Thank you!

• ###### Re: Hide a table when all values are zero or blank

Hi , i have a question in similar lines ,

how to hide a dimnsion when there is a null

say like i have

Brand as dimension adn values are as follows

xxx,

yyy,

zzz,

-,

then how can i remove that' -' ( null value) dimensionout of my straight table

• ###### Hide a table when all values are zero or blank

sorry , that i could able  figured that out by selecting an option supress nul vales

thanks