How to display the value instead of null value in a straight table?

[#1]

Hi Community

I have a straight table in that I am calculating an expression  that will display the count of materiel for all the days started from Sunday to Saturday  as below.

Division	Expression =aggr(count(materiel),Division)
Atlanta	-
New jersey	2000
New York	523
Texas	251
CDC	412
Sidney	321

Here for my Dimension Division field value Atlanta i am getting a null value so 

here  I want to populate  a value that is calculated for the days Monday to Friday instead of null value for Atlanta.Can someone let me know the possible ways to handle it.

Thanks

[#2]

It is simple:

Your chart type is straight table. Let your dimension be Division, then add expression: sum(Material). Because of sum, '-' will disappear. Try that and let me know whether it worked.

Best,

T

[#3]

Hi Tibor Sebok

I want count only not the sum.

Thanks

[MarcoWedel]

Alt(expression1, expression2)