Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
here is my QVW
Hi,
try this:
=sum([sum(valeur)/3])- RangeSum(Above([sum(valeur)/3]),RowNo())
In the script or front end?
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?
frond end bro,
in the expression section
here is my QVW
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]))
Thanks bro
haha Sunny we had already faced the same problem.. I'm not gonna ask you why we Should use this or the other