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] )
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