accumulate in straight table

[syukyo_zhu]

i have a table A in which i have my sales et sales of product A per date.

date	sales	product A
01/01/2015	100	50
02/01/2015	101	51
03/01/2015	102	52
04/01/2015	103	53
05/01/2015	104	54
06/01/2015	105	55
07/01/2015	106	56
08/01/2015	107	57
09/01/2015	108	58
10/01/2015	109	59

I want to calculate the rate cumulate product/sale, so i use "full accumulation" in my expression, it's ok for columns sales et product, but false for column rate cumulate

date	sales	product A	rate cumulate
01/01/2015	100	50	0,5
02/01/2015	201	101	1,002487562
03/01/2015	303	153	1,507438057
04/01/2015	406	206	2,01482722
05/01/2015	510	260	2,524631141
06/01/2015	615	315	3,036826263
07/01/2015	721	371	3,55138937
08/01/2015	828	428	4,068297583
09/01/2015	936	486	4,587528352
10/01/2015	1045	545	5,109059452

. i want to get a result like this one.

date	sales	product A	rate cumulate
01/01/2015	100	50	0,5
02/01/2015	201	101	0,502487562
03/01/2015	303	153	0,504950495
04/01/2015	406	206	0,507389163
05/01/2015	510	260	0,509803922
06/01/2015	615	315	0,512195122
07/01/2015	721	371	0,514563107
08/01/2015	828	428	0,516908213
09/01/2015	936	486	0,519230769
10/01/2015	1045	545	0,5215311

thanks

[Anonymous]

I guess the labels are same as the data model fields in this case.....may be you can give a lable like 'Accumulated Sales' and Accumulated Product and then try to use the labels

[syukyo_zhu]

Or how can i calculate a number accumulate in my straight without use option "full accumulation"

[sunny_talwar]

Did you look at the sample application I posted? It shows you how you can calculate the cumulative numbers without using full accumulations.

Hope it helps.

Best,

S

[sunny_talwar]

Application attached

Expressions Used

1) RangeSum(Above(Sales, 0, 500))

2) RangeSum(Above([Product A], 0, 500))

3) RangeSum(Above([Product A], 0, 500))/RangeSum(Above(Sales, 0, 500))

All these are without accumulation.

[syukyo_zhu]

It works

thanks

[sunny_talwar]

Great, I am glad I was helpful.

Best,

S