
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sum of rows?
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this
RangeSum(Above(NewExpression, 0, RowNo()))/RangeSum(Above(TotalExpression, 0, RowNo()))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure how you getting 43.3% and 43.4% for ID 3 and 4, resp.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry its a typo its 43.3% fro ID 3 and 4 respectively.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How are you getting those values?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
for ID 1 it is 5/10 = 50%
for ID 2 it is (8+5)/20+10) = 43%

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this
RangeSum(Above(NewExpression, 0, RowNo()))/RangeSum(Above(TotalExpression, 0, RowNo()))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In Script:
Load *,
(CumulativeNew/CumulativeTotal)*100 as New%;
Load *,
Rangesum(New,peek(CumulativeNew)) as CumulativeNew,
Rangesum(peek(CumulativeTotal),Total) as CumulativeTotal
From Table;
