Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be use these settings on the presentation tab of the chart properties
sometimes if above option does not work then implement this if statement. If (len(feild)=0,0,yourexpression)
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)?
you can either use the expression you posted or use len(VD)=0. let me know if that helps.
tomorrow in the office I try this and then tell you if it works.