filling blank cells in matrix 1

[mjd3000]

I have created a matrix with data in it, but there are quite a few blank cells where there is no data.

I have tried this (the field is a Sum field) : =IIF(Sum(Fields!Total.Value) = "", 0, Sum(Fields!Total.Value)) But I get an error that it is out of scope (I don't get this error when I just use Sum(Fields!Total.Value)).

Can anybody tell me how I can I replace the blanks with zeroes?

 

[jymm]

check out how to do the scope for the sum function.

http://technet.microsoft.com/en-us/library/ms159134.aspx

there are a bunch of ways around it if this does not help.