5 Replies Latest reply: Nov 15, 2013 4:24 PM by Clever Anjos RSS

    Chart displays 0(zero) for null values.

      Hello All,


      I have a line chart with 2 expression, one displays YTD fiscal year data and other displays entire last fiscal year's data.

      For current year values for future month in DB are nulls but in Chart object sum({<YTD calculation>}DataField) displays zero instead of nulls for future months.


      I also need to display average trend for current year, since 0 is a values my average is skewed as the denominator is always 12.


      Please Advice.