I'm wondering if someone could help me.
As you can see on the below image I have created a table, I would like it to show just accounts that are 'flagged' however it is showing all accounts and putting a dash in the expression for those that aren't 'flagged'.
How do I hide these null values?
For a Straight Table:
Chart Properties --> Dimensions tab--> Used Dimensions (on the right)..
select the field for which you do not want null values and tick "Suppress when Value is null" (see attachment)
For a Table box see ecolomerreply
I assume that the column Top Branch is an expression. For null/0 lines to be suppressed, every expression on the line must return a null or zero. So modify the Top Branch expression to something like:
If(len(Column(2)) > 0, ...expression for top branch...)
This will return null if [Non Allocated] (Column 2) is null.
Thanks everyone but none of the suggestions have worked.
I don't want to show the rows that do not have a 'flagged' in the non allocated column.
Any other suggestions? It seems like such an easy thing to do but I can't figure it out.
Is Open Date an expression? If yes:
=If(len(Column(3)) > 0, ...expression for open date...)
=If(len(Column(3)) > 0, ...expression for top branch...)
Make sure that the column number is the correct expression number for the column titled [Non Alloc...], and the suppress null values is checked on the Properties | Presentation page.
If all the expressions return numeric 0 or null, the line will be suppressed. If the line is still showing check which expression is returning something other than 0 or blank.Blank strings will be displayed as they are not null.