Remove Null values from Straight Table Chart with Expressions

[cliff_clayman]

I have a straight table chart with 4 dimensions and 3 expressions.  The 3 expressions are just SUMs.  I am getting null values in one of my fields that I do not want to see.  I checked Suppress When Value Is Null for that Dimension, but the null values still display.  How can I remove those null values?

[trdandamudi]

Can you please share a sample so that we can take a look.

[cliff_clayman]

Division	Unit	Code	Age	YTD Avg Mo	YTD Avg $	YTD Avg Items
	1	1234	30	1	1000	100
	2	4567	60	2	2000	200
	3	7890	90	3	3000	300
	1	1234	30	1	1500	150
	2	4567	60	2	2500	250
	3	7890	90	3	3500	350
	1	1234	30	1	1250	125
	2	4567	60	2	2250	225
	3	7890	90	3	3250	325
A	1	1234	30	1	1000	100
A	2	4567	60	2	2000	200
A	3	7890	90	3	3000	300
B	1	1234	30	1	1500	150
B	2	4567	60	2	2500	250
B	3	7890	90	3	3500	350
C	1	1234	30	1	1250	125
C	2	4567	60	2	2250	225
C	3	7890	90	3	3250	325

[sunny_talwar · Accepted solution]

For the Division dimension can you try a calculated dimension....

If(Len(Trim(Division)) > 0, Division)

and then use 'Suppress When Value is Null' option on the dimension tab...