Accumulation with rangesum

michael_maeuser — Fri, 27 Jan 2012 08:55:30 GMT

Hello,

I have a table chart with the Product as Dimension and the following formula:

sum(if(Lagerwert.Datum=Today(), Lagerwert.Lagerwert))/
sum(total if(Lagerwert.Datum=Today(), Lagerwert.Lagerwert))

Now I want to accumulate these Values without accumulation function. Is it possible with range sum or s.th. else?

Thanks in advance!

Michael

Re: Accumulation with rangesum

lironbaram — Fri, 27 Jan 2012 09:59:29 GMT

check the attach example hope it helps you