Tuesday 19 May 2015

How to change null values as n/a in view?

We can handle the Null Values in 3 ways

1.Using Filter we can eliminate the Null Values.
2.Using Axis-->Format--> Marks --> Hide option we can hide the "Null values".
3.We can also use a calculated field to convert Nulls to Zeros using "IsNull" function.


Ex:IIF(ISNULL([Actual] ), 0, [Actual] )


No comments:

Post a Comment