How to Calculate

[alvinford]

Hi I have the following issue

I am calculating the G% value as (TY-LY) / LY using the below data.NO issues in calculating the G%

I want to Calculate the P% using the cummulative values Row wise i.e

TY	LY	G %	P%	P derived using TY and LY
654.6	490.1	33.5	33.5	(654.6 -490.1) / 490.1
514.1	404.1	27.2	30.7	((654.6+514.1) - (490.1+404.1))/(490.1+404.1)
550.7	597	-7.7	15.3	((654.6+514.1+550.7) - (490.1+404.1+597.0))/(490.1+404.1+597.0)
569.8	1,017.60	-44	-8.8	((654.6+514.1+550.7+569.8) - (490.1+404.1+597.0+1,017.6))/(490.1+404.1+597.0+1,017.6)
908.7	806.8	12.6	-3.5	((654.6+514.1+550.7+569.8+908.7) - (490.1+404.1+597.0+1,017.6+908.7))/(490.1+404.1+597.0+1,017.6+908.7)

In the above example I have calculated manually . How can I achieve this in QlikView.

Thanks in Advance,

Regards,

Alvin.

[deepakk]

hi,

I hope attach application helps you out.

[alvinford]

Thanks Deepak,

Regards,

Alvin.

[#4]

Hi,

one of solutions, P%;

(RangeSum(above(sum(TY),0,NoOfRows()))-RangeSum(above(sum(LY),0,NoOfRows())))
/RangeSum(above(sum(LY),0,NoOfRows()))

regards,

kaz