Showing all values except NULL

[#1]

I have a chart where I want to show last 12 Months on the X axis everytime,even if no data is available. I have used the 'Show all values' in the Dimension tab. However this also shows a NULL value sometimes(when no data is available). I have checked the option 'Suppress when value is NULL' but it doesnt make any difference. Is there any way to hide this null value?

[aveeeeeee7en]

use {1} in your expression. It will show all data.

like this:

Sum({1}Amount)

Regards

Aviral Nag

[amit_saini · Accepted solution]

Try something like below:

where Your_field_name <> ''; (Use in script)

or

=If( Your_field<>0,Your_field,null()) ( Use in Expression)

Thanks

AS

[sujeetsingh]

Try supress null on Presentation tab

[#5]

Thanks. I used it in the expression, and its working now