accumulative sum not working

[#1]

Hi qlikview communtity,

I am trying to make a accumulative sum on a straight table but nothing seems to work. I have the belowtable:

Date	EmplRef	MinutesWorked	FlexGained
			59
14/10/2013	FL238	464	-16
15/10/2013	FL238	481	1
16/10/2013	FL238	513	33
17/10/2013	FL238	481	1
21/10/2013	FL238	465	-15
22/10/2013	FL238	535	55

I have tried the FullAccumulation option, rangesum(above(FlexGained)) options so far none of them worked.

Any ideas???

[#2]

Hi,

Please try this one:

=rangesum(Above(sum(FlexGained),1,RowNo()))

[#3]

Try this

rangesum(above(Flexgained,0,rowno()))

hope it will help

[#4]

Nop. No luck. I got only zero values on all rows.

[#5]

This did not work either. I got the FlexGained values replication on each row.

[#6]

will you attach the sample

[Gysbert_Wassenaar · Accepted solution]

Since you're using two dimensions you need the total keyword in the above() function:

rangesum(above(total sum(FlexGained),0,RowNo(total)))

See attached example.

[#8]

Thats it...You are right.

[er_mohit]

try this

rangesum(above(sum(FlexGained),0,rowno()))

[#10]

What about doing the same calculation inside the script. Is that possible ??? using peek or above or something like that??