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]

Hi Jagan,

Didnt work.

Can You edit the expression directly ?

RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'},Séria = {'Plán'}>}Čiastka),0,RowNo(TOTAL)))

RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'},Séria = {'Účtovníctvo'}>}Čiastka),0,RowNo(TOTAL)))

Thanx in advance.

Duski

[jagan]

Hi,

Try this

=RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'},Séria = {'Plán'}>}Čiastka),0,RowNo(TOTAL)),

Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'},Séria = {'Účtovníctvo'}>}Čiastka),0,RowNo(TOTAL)))

Regards,

Jagan.

[#4]

Thanx Jahan,

your expression worked :-), but the result isn't correct 😞

The correct result is:

Thank you.

I'm using a Personal Edition QV, because I'm experimenting only a few days with it before buying a full licence.

Can you explain you suggestion from Jul 9 2014, 10:34 PM without using your qw attached ?

Thanx in advance.

Duski

[#5]

Hi, Manish, thank you for yuor response.

But the result of your suggestion is some strange 😞

What'swrong with me ?

Thanx in advance

Duski

[MK_QSL]

CHeck enclosed file..

[#7]

Thank you, Manish,

but I'm sorry, I can't 😞

I'm using a Personal Edition QV, because I'm experimenting only a few days with it before buying a full licence.

Is this the end of your help ?

Duski

Edit.

My settings look like this:

Duski

[MK_QSL]

1) Create a Bar Chart

Dimension

Use Aggregated Dimension

=If(Year(Obdobie)=Year(Today()),Obdobie)

Also tick suppress when value is null in dimension tab

Expression

RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'}, Séria = {'Plán'}>}Čiastka),0,RowNo(TOTAL)))

and

RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'}, Séria = {'Účtovníctvo'}>}Čiastka),0,RowNo(TOTAL)))

Go to Sort Tab

Expression -- Ascending Order

=If(Year(Obdobie)=Year(Today()),Obdobie)

Hope this helps..

[#9]

Thank You Manish, I made all suggested settings, but no success 😞

In previous post I added screenshots of my settings BEFORE your suggestions.

Did you discover something wrong ?

Duski

[MK_QSL]

Follow my given steps ...

[MK_QSL]

OMG... i found problem in your expression..

RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'}, Séria = {'Plán'}>}Čiastka),0,RowNo(TOTAL)))

and

RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'}, Séria = {'Účtovníctvo'}>}Čiastka),0,RowNo(TOTAL)))

are two different expressios...

use two expression

RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'}, Séria = {'Plán'}>}Čiastka),0,RowNo(TOTAL)))

RangeSum(Above(TOTAL sum({$<[Kód]={D01TSČ},Fáza = {'B01REAL'}, Séria = {'Účtovníctvo'}>}Čiastka),0,RowNo(TOTAL)))