Percentage with full accumulation

[#1]

Hi guys,

Question concerning the full accumulation option.

I have a graph with sum(Sales), accummulated over the year (option full accumulation)

I already have the difference between years (same month,  but year -1).

I now want to show the accummulated difference, but this is where Qlikview does strange things.

I am using the expression:

=(sum({$<Month=, Year={$(=only(Year))}>}Sales)

/

sum({$<Month=, Year={$(=only(Year)-1)}>}Sales))

-1

As you can see, it does not show me the correct value. The percentage for april should be:

(8.712.137/15.331.837)-1 = -43% and not -183%??

Thanks for your help!

Zipke