Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like this. I want to create another column in the front table which will give me running total of Value. Eg ValueSum column like shown in the example
Project Code | Activity ID | Value | *ValueSum* |
1 | 001 | 3 | 3 |
1 | 002 | 2 | 5 |
1 | 003 | 4 | 9 |
1 | 004 | 1 | 10 |
1 | 005 | 7 | 17 |
2 | 006 | 6 | 23 |
2 | 007 | 9 | 32 |
2 | 008 | 14 | 46 |
2 | 009 | 5 | 51 |
In the front end, I would suggest using Modifier > Accumulation.
This can be found under Measures properties.
I have to do this in front end table
Hi,
Try this in your measure,
=aggr(RangeSum(Above(Sum( Value),0, RowNo())),[Activity ID])
try this
sum(aggr(rangesum(above(sum(Value),0,rowno())),Value))
Hi , Try this
aggr(RangeSum(ABove(Sum(Value),0,RowNo())),Value)