Wednesday, March 21, 2012

Getting rid of 'NaN' values in the Graph

Hi folks,

I run into problems where some metrics have value associated with dim attributes Markets where some don't have... The graph shows NaN, in the reporting services. Is there a way to get of NaN. something like filter out.

--Imran

Use the dataset filters and the following filter expressions:

CStr(Fields!YourField.Value) <> "NaN" AND

Fields!YourField.Value <> Nothing

Shyam

No comments:

Post a Comment