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]

I meant: is the result for Dec 2014 for Series Plan = 29 000 000 and for May 2014 for Series Uctovnictvo 3 686 616 ?

I do need my chart with this accumulated data:

Thanks in advance.

Duski

[#3]

Dear Manish, don't give up, pleeeease!

I feel, we are not far away from the goal 🙂

Duski.

[MK_QSL]

OK... let me know what is the chart you want to use..

what are the dimension ..

how many expressions....

also, if possible, upload your result in excel as a straight table... I will help you out...

[#5]

Thank you, Manish 🙂

I'd like to see this cumulative chart :

See attached EXCEL - Sheet: Goal1.

Thanx in advance.

Duski

[MK_QSL]

Sorry for late reply... was busy in my own project.....

Create a Bar Chart

Dimension

Use Calculated Dimension

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

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)))

Hope this will solve your problem...

[jagan]

Hi Dusan,

Please find attached file, hope it helps you.

Regards,

Jagan.

[#8]

Thank you Manish,

But I think, I make a newbie mistake in the expression writer  😞

When I set both formulas into expression writer, I receive "Garbage after expression 'RangeSum'

What's wrong ?

Thanx in advance.

Duski

[jagan]

Hi,

I think , is missed in the first line ending, and you need to add bracket at the end of second line.

Regards,

Jagan.

[#10]

Thank You, Jagan.

I did, but no success 😞

Regards,

Duski

[jagan]

Hi,

Remove ) at the end of first line and second line.

Regards,

Jagan.