Full Accumulation in Expression

[#1]

Hi, there.

I'm a newbie in QV and cannot solve my problem with full accomodation in expression.

Expression looks like this, crucial dimension is Seria:

sum(aggr(RangeSum(above(sum({$<[Kód]={D01TSČ}>}Čiastka),0,RowNo(TOTAL))),Obdobie,Séria,Fáza,Kód,Rok))

I need cumulatives like this BUT IN EXPRESSION !

Thanks in advance.

Duski

[#2]

Thank you, Manish.

This was the first thing I did today in the morning.

But the expression writer reported an error 'Garbage after expression RangeSum', which I reported at 2:57 AM ...

I repeatly cooied CTRL+C, CTRL+V from your post - resylt the same:

And no data 😞

Duski

[MK_QSL · Accepted solution]

My friend, I said two different expressions... not in one...

[#4]

Yesssss !

That's it !!!!!

Sorry for my newbie naivette 😞

Thank you very ery much for your time, Manish.

But: all this was only preparation for solving my real problem, which I posted here on Tuesday and up to now without any response. If you are got started, can you have a look at Cumulative Sum - Dimension Problem ?

Thanx in advance.

Duski

[MK_QSL]

Glad that at last you got solution for this post... for another question, I would try tonight from home...

[#6]

Thank you, Manish,

but have a nice evening 🙂

I adapted your solution into my main problem AND IT WORKS !!!

Thank you once more for your time, you helped me enormous.:-)

Duski

[#7]

Hi, Manish,

one more simple question:

I have an expression...

(Rangesum(above(total Sum({$<[Séria]={Účtovníctvo}>}Čiastka),0,RowNo(total))))/(Rangesum(above(total Sum({$<[Séria]={Plán}>}Čiastka),0,RowNo(total))))

... and I need to add a filter for dimension Obdobie <= UZAVRENEOBDOBI,

where UZAVRENEOBDOBI is another dimesion.

How can I do it ?

Thanx in advance.

Duski