Accumulation with null values

[#1]

If you turn on full accumulation on a chart and an expression does not have a value in the maximum value of the first dimension, the accumulation reverts back to zero. For example, open the consulting services sample, go to the Consultants tab, add a list box for the "Consulting" field, select 20 and watch the animation. Only those consultants with a "20" for consulting in 2008-Q4 will have an accumulated value at the end of the animation. Is this by design?

[#2]

To get around this, use the following expression:

rangesum(above(ChartFieldName,1,rowno()))

Look at the documentation for rowno() and noofrows() to suit your situation.

-Jay

[yblake]

To change default behaviour (by design), uncheck "suppress null values" and "suppress missing values" in presentation tab.

[#4]

I answered too quickly, sorry.

[#5]

In addition to Yves suggestion, I also had to check "Show All Values" for the YearQtr dimension to get the desired behavior. I'm using 8.5.