Surpress null value

[davinfrost]

hi guys, 

is there any way to surpress null value on Text Object?

='Total So Number'&' = '&count(distinct [So Number Edit])
& ' Total Invoice = '&Count(DISTINCT([Total SO No]))

there is a null value on field [Total SO No]

many thanks..

[sasikanth]

Hi,

Try below code,

='Total So Number'&' = '&count(distinct [So Number Edit])
& ' Total Invoice = '&Count( distinct if (not isnull ([Total SO No]) OR length([Total SO No])>0 , [Total SO No]))

OR

='Total So Number'&' = '&count(distinct [So Number Edit])
& ' Total Invoice = '&Count( DISTINCT {< [Total SO No] -={'-'}>} [Total SO No])

Thanks,

Sasi