Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a data like as shown below,
ID | Value |
1 | 5 |
2 | 10 |
3 | 15 |
4 | 20 |
But i need to show in straight table as Sum Value (adding with previous value
I am getting the output as
ID | Value | Sum Value |
1 | 5 | |
2 | 10 | 15 |
3 | 15 | 30 |
4 | 20 | 50 |
My expected output should be like below
ID | Value | Sum Value |
2 | 10 | 15 |
3 | 15 | 30 |
4 | 20 | 50 |
where len(trim([Sum Value])) >0
where [Sum Value] >0
Hi Thakur,
Sum Value is an expression
Hi Yoganantha
I know [Sum Value] is an expression but you must have given an alias to it. Use where clause on top of it.
Thanks
Pradosh
Thanks
Welcome. If this is resolved , please close the thread.
try this..
RangeSum(Above(Sum([Value]), 0, RowNo(TOTAL)))
or
RangeSum(Above(Sum([Value]), 0, RowNo()))