Extra entry on chart when using above()

[#1]

Hi Folks

I have a line/bar chart where onve of the expressions is:

Sum

(Value1) - above(Sum(Value1))

This gives me the movement between two periods as the dimension is QuarterEnd, the problem is that when I use the above() function the chart will give me an additional plot/data after the last Quarter. For example, I have selected a reporting date of 30 Jun 2008 (which gives me a dataset of everything prior to that date) but my chart gives me a bar after 30 jun 2008 with no date on it.

Anybody experienced this?

If you have, have you found a solution?

Cheers,

Nigel.

[sathishkumar_go]

Hi try this fromula

if(date = '30 jun 2008',sum(Values1),sum(Values1) - above(sum(Values1))

I hope it ll help for u

-Sathish

[rwunderlich]

Does it look different if you use:

sum(Value1) - above(Sum(Value1))

-Rob