dash instead of nothing

[V2008]

I have a matrix whose column value is =Sum(iif(Fields!x.Value>0,Fields!x.Value,Nothing)) which is working, I can see row total and column total too.

But I want to display "-" if value is zero and still wants total.

 

[jymm]

I have never tried it (and not at a point where I could) have you tried nesting another iif? like =iif(Sum(iif(Fields!x.Value>0,Fields!x.Value,Nothing))=0,"-",Sum(iif(Fields!x.Value>0,Fields!x.Value,Nothing)) )

sorry - I am not at a place where I can confirm the format or the working - hopefully you get the idea...