filling empty cells

[#1]

Hi,

in a table I use the formular

=round(Sum({<endyear={$(=max(endyear))}>} VD)/Count({<endyear={$(=max(endyear))}>} distinct Productnumber),'0,1')

some cells have no value, are empty.

But I need a 0 instead an empty cell.

The Icon in the Table-Menue to showt nullvaliues doesn't work and the skript is very complicated. So I search for a solution in this specific table.

Thanks!

[sunny_talwar]

May be use these settings on the presentation tab of the chart properties

[Anonymous]

sometimes if above option does not work then implement this if statement. If (len(feild)=0,0,yourexpression)

[#4]

like this?

if(len(Sum({<endyear={$(=max(endyear))}>} VD)/Count({<endyear={$(=max(endyear))}>} distinct Productnumber) = 0,0, round(Sum({<endyear={$(=max(endyear))}>} VD)/Count({<endyear={$(=max(endyear))}>} distinct Productnumber),'0,1')

or what do you mean with len(field)?

[Anonymous]

you can either use the expression you posted or use len(VD)=0. let me know if that helps.

[#6]

tomorrow in the office I try this and then tell you if it works.