How to write a Cumulative expression for attached data

[kunkumnaveen]

Hello All,

             I was trying to write a cumulative sum expression but some reason it is giving zero as out put ..what i mean is

                          For

                                      Calmonth(Field) =201705-----it has to sum 201704+201705

                                                                 =201706------it has to sum 201704+201705+201706

                                                                    ........So on

                               Expression i tried is :

                                                                 RangeSum(Above(sum(VOLUME)), 0, RowNo())

Any suggestion on how to write a cumulative expression for below attached data ..

[Anil_Babu_Samineni]

Try this?

Rangesum(Below(Sum(VOLUME),0),Above(VOLUME,1,RowNo(TOTAL)))

[sunny_talwar]

Output as zero in a chart or are you doing this in a text box object?

[kunkumnaveen]

Hello Anil,thanks for your reply..

I tried your expression what i am getting is

when i tried SUM(volume) i am getting same

I have attached Sample data aswell......

[kunkumnaveen]

HI ,i am doing it in Table....

[Anil_Babu_Samineni · Accepted solution]

Then Try this?

RangeSum(above(TOTAL sum(VOLUME),0,RowNo(TOTAL)))

[kunkumnaveen]

Any Suggestion Please

[Anil_Babu_Samineni]

Is my second reply won't for you?

[effinty2112]

Hi Naveen,

The brackets in your original expression were wrong, try;

Rangesum(Above(Sum(VOLUME),0, RowNo()))

gives:

CALMONTH	Sum (VOLUME)	Rangesum(Above(Sum(VOLUME),0, RowNo()))
	540620590.72295	0
201704	88254316.243012	88254316.243012
201705	108867027.09298	197121343.33599
201706	142117893.154	339239236.48999
201707	71972231.979963	411211468.46995
201708	105148241.14499	516359709.61495
201709	24260881.108001	540620590.72295
201710	0	540620590.72295
201711	0	540620590.72295
201712	0	540620590.72295
201801	0	540620590.72295
201802	0	540620590.72295
201803	0	540620590.72295

Regards

Andrew

[hari8088]

Use Full accumulation option in expression tab-click on this for particular chart