sum of rows?

[qlikuser222]

Hi ALL,

I have the following requirement and need help.

Can anyone please help to create the fifth column (i.e NewColumn %) in belwo table?

ID  Total  New  Old    New/Total %       NewColumn % i.e (New(5+8)/Total(10+20))

1      10     5         5       50%                        50%

2       20    8         12      40%                  43.3%

3        0     0          0        0                          43.3%

4        0      0         0       0                            43.4%

Thanks

[sunny_talwar]

Not sure how you getting 43.3% and 43.4% for ID 3 and 4, resp.

[qlikuser222]

Sorry its a typo its 43.3% fro ID 3 and 4 respectively.

Thanks

[sunny_talwar]

How are you getting those values?

[qlikuser222]

for ID 1 it is  5/10 = 50%

for ID 2 it is  (8+5)/20+10) = 43%

[sunny_talwar · Accepted solution]

May be like this

RangeSum(Above(NewExpression, 0, RowNo()))/RangeSum(Above(TotalExpression, 0, RowNo()))

[aarkay29]

In Script:

Load *,

(CumulativeNew/CumulativeTotal)*100  as New%;

Load *,

Rangesum(New,peek(CumulativeNew))  as CumulativeNew,

Rangesum(peek(CumulativeTotal),Total)  as CumulativeTotal

From Table;