Hi There,

I have a matrix where there the results of some cells show as NaN. I think this is because it is not a straight forward aggregation....The data within the matrix is as follows...

=(sum(Fields!income.Value)/ sum(Fields!bal60.Value))*100

I get NaN when there are now rows for a given cell.

Can I do the same as I can in an Excel pivot table where I can set the cell to display something other than NaN...e.g. No Data?

Any help, much appreciated.

I've worked it out....NaN appears when you divide 0 by 0....so my expression needs to be...

=iif(
(sum(Fields!income.Value)/ iif(sum(Fields!bal60.Value)=0,1,sum(Fields!bal60.V alue)))*100=0,
"No data",
(sum(Fields!income.Value)/ iif(sum(Fields!bal60.Value)=0,1,sum(Fields!bal60.V alue)))*100)

If anyone can think of any other ways I'm all ears..

Cheers...

check out the following post, it's a bit more elegant than a large
expression.

http://blogs.digineer.com/blogs/jaso...08/18/374.aspx