show 0 in line chart

[#1]

hi everyone,

I created a line chart für the profit and the linechart has the day of a month and the years as dimensions. day is on the x-axis and year on the y-axis. so far so good. I always display the last 4 years. and for example: 2010 the 7th of march was a sunday and I didn't have any profit!! but my chart I not displaying it as 0. It basically makes a straight line to the next day with profit.

does anyone know how to solve this?

regards,

MT

[#2]

Hi,

Hope this helpful for you

[Anonymous]

hi,

Try this expression

if(isnull(sum(fieldname) or fieldname=' ',0,sum(fieldname)) 

where field name is your value or amount

Best wishes,

anant

[udit_kumar_sana]

Hi,

You can write like this in expression.

If(isnull(expression),'0',Expression)

Then tick mark show value on data points in expression tab for this expression.

Regards,

Udit

[#5]

thanks for all your answers but none of your suggestions works. does anyone of you have another idea??

[#6]

Hi,

Try going to properties in your line chart and in presentation tab,

uncheck 'Suppress zero-values' and check 'Zero on bars'

This should work fine.