Display zero instead of blank in Matrix on Paginated Report

[ShaelynFrench]

Hi,

I've tried all of the tricks --- using:

=Sum(Fields!QMonthly_Actual.Value) +0

or

=IIF(IsNothing(Sum(Fields!QMonthly_Actual.Value)), 0, Sum(Fields!QMonthly_Actual.Value))

and both formulas still return a blank in the report instead of a zero. Am I missing something?

Thanks!

[ShaelynFrench · Accepted solution]

I solved it -- I was using a custom number format: #,###;(#,###) that did not specify how to handle the zero so it was showing up blank. I changed it to: #,###;(#,###);0 and that solved it.

[d_gosbell]

I just tested both of the approaches you've tried here and they both worked fine for me.

So you have something else going on in your report.