6 Replies Latest reply: Oct 24, 2013 4:14 AM by Tresesco B RSS

    accumutative sum in script

      Hi qlikview communtity,

       

      I am trying to make a accumulative sum in the script but nothing seems to work. I have the belowtable:

       

      DateEmplRefMinutesWorkedFlexGained
      59
      14/10/2013FL238464-16
      15/10/2013FL2384811
      16/10/2013FL23851333
      17/10/2013FL2384811
      21/10/2013FL238465-15
      22/10/2013FL23853555

       

      I have managed to do it on a straight table but I need it inside the script.

       

      Already tried:

      RangeSum(FlexGained,peek(AccumFlexGained)) as AccumFlexGained


      but i got some lagre negative numbers back isted of an accurate result

       

      Any ideas???