How to ingnore the nulls in this expression?

[#1]

Hello Experts,

I have a funnel chart on which I have a dimension like =if(PipeStatus_Reached_opp_key >=1,PipeName)

And and expression =rangesum(below(count({< dim_opportunity_master.Effective_end ={'31/12/9999'}>}  distinct dim_opportunity_master.crm_opportunity_id),0,6))

The problem I have is, looks like there are some null values on selected Calendar Date due to which one of the dimensions is blank and supressed and my chart doesnt look good. I want to see the next value in place of null value when something is null or blank.

Please look at the original post where I have attached a sample: http://community.qlik.com/message/141712#141712 if you need more info.

Thanks a ton in advance,

Mady