Announcements
cancel
Showing results for
Did you mean:
Creator

## sum of rows?

Hi ALL,

I have the following requirement and need help.

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

1 Solution

Accepted Solutions
MVP

May be like this

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

6 Replies
MVP

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

Creator
Author

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

Thanks

MVP

How are you getting those values?

Creator
Author

for ID 1 it is  5/10 = 50%

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

MVP

May be like this

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

Specialist

In Script: