Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
My friend, I said two different expressions... not in one...
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
Glad that at last you got solution for this post... for another question, I would try tonight from home...
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
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