Folks
Following up my many posts on this (thanks to all) is there any way of limiting the Running Sum to a max limit - in my case 864? So that upon exceeding 864 it is set at 864. Thereafter reducing accordingly if subsequent weeks are in deficit.
See Mick example below. 1160 should be 864 and and his suesequent entry (-130) should return 734.
ItemID--Name--Week-------Fleximins--RunningSum--FlexiMax
54------Mick--02/03/2009-: 420----------420-------420
55------Mick--09/03/2009-: 360----------780-------780
60------Mick--16/03/2009-: 380---------1160-------864
70------Jane--02/03/2009-: 270----------270-------270
75------Jane--09/03/2009-: 360----------630-------630
80------Jane--16/03/2009-: 320----------950-------864
85------Jack--02/03/2009-: 270----------270-------270
90------Jack--09/03/2009-: 480----------750-------750
95------Jack--16/03/2009-: 230----------980-------864
99------Mick--23/03/2009-: -130---------1030-------864
I'm self taught and only know what I've done before. Help from some expert would be great.
Thanks
Fozi
Following up my many posts on this (thanks to all) is there any way of limiting the Running Sum to a max limit - in my case 864? So that upon exceeding 864 it is set at 864. Thereafter reducing accordingly if subsequent weeks are in deficit.
See Mick example below. 1160 should be 864 and and his suesequent entry (-130) should return 734.
ItemID--Name--Week-------Fleximins--RunningSum--FlexiMax
54------Mick--02/03/2009-: 420----------420-------420
55------Mick--09/03/2009-: 360----------780-------780
60------Mick--16/03/2009-: 380---------1160-------864
70------Jane--02/03/2009-: 270----------270-------270
75------Jane--09/03/2009-: 360----------630-------630
80------Jane--16/03/2009-: 320----------950-------864
85------Jack--02/03/2009-: 270----------270-------270
90------Jack--09/03/2009-: 480----------750-------750
95------Jack--16/03/2009-: 230----------980-------864
99------Mick--23/03/2009-: -130---------1030-------864
I'm self taught and only know what I've done before. Help from some expert would be great.
Thanks
Fozi