edit an expression in table by month

[aminehaddar]

Hello the community,

I have this table:

date	sum(valeur)/3
201701	684
201702	1548
201703	3253
201704	4802
201705	6297
201706	7553
201707	8149
201708	8564
201709	9151
201710	10146
201711	11237
201712	12000

The problem is that these number are incremental by month.

I need to have this result:

date	sum(valeur)/3
201701	684
201702	864
201703	1705

...

Anyone can help please?

Regards

[YoussefBelloum]

Hi,

try this:

=sum([sum(valeur)/3])- RangeSum(Above([sum(valeur)/3]),RowNo())

[sunny_talwar]

In the script or front end?

[aminehaddar]

I got this:

date	sum(valeur)/3	x
201701	684	-1
201702	1548	-686
201703	3253	-1551
201704	4802	-3257
201705	6297	-4807
201706	7553	-6303
201707	8149	-7560
201708	8564	-8157
201709	9151	-8573
201710	10146	-9161
201711	11237	-10157
201712	12266	-11249

Any suggestion?

[aminehaddar]

frond end bro,

in the expression section

[YoussefBelloum · Accepted solution]

here is my QVW

[sunny_talwar]

I think the expression should be this

=RangeSum(Sum([sum(valeur)/3]), -Above([sum(valeur)/3]))

or this

=RangeSum(Sum([sum(valeur)/3]), -Above(TOTAL [sum(valeur)/3]))

[aminehaddar]

Thanks bro

[YoussefBelloum]

haha Sunny we had already faced the same problem.. I'm not gonna ask you why we Should use this or the other