Cummulative week

[#1]

Hello,

I have question:

I want to cummulate, in a period of 16 week, 4 week in a row

For example:

Name	week	aantal	cumm
pdr	1	1	1
pdr	2	1	2
pdr	3	1	3
pdr	4	1	4
pdr	5	1	1
pdr	6	10	11
pdr	7	1	12
pdr	8	1	13
pdr	9	3	3
pdr	10	2	5
pdr	11	1	6
pdr	12	1	7
pdr	13	1	1
pdr	14	1	2
pdr	15	1	3
pdr	16	1	4

Can anybody help me?

Patrick

[amars]

hi Patrick,

For Sum over a range you can use either above function, if there is no bifurcation required or use mapping tables

like

week AsOnWeek

1 1

2 1

2 2

3 1

3 2

3 3

& use AsOnWeek instead of week

Thanks

Amar