Default null values to zero

[A4e]

hi

i have an owc11 pivottable which displays 'empty' cells when there is no
data... i wish it to display 0.

please help?

thanks, jake

 

[vapor]

There's a couple of ways to deal with this.
1. Purge the null data from the cube.
2. Modify the MDX expression to remove null values.
3. Use a numberformat on the appropriate cell.

--
--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99