Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 2 fields in a straight table and the Increment field Values should differ with the Transaction value.
salary Increment
100 100
-20 80
5 85
-10 75
-80 -5
20 15
Please help me out.
I guess you have more then one dimension in your chart... try this
RangeSum(Above(TOTAL Sum(salary), 0, RowNo(TOTAL)))
May be try this for increment
RangeSum(Above(Sum(salary), 0, RowNo()))
Hi Sunny
The expression is showing the cumulative difference but isn't showing the resulted value.
Resulted value? can you elaborate?
salary ( O/p)Increment RangeSum(Above(Sum(salary), 0, RowNo()))
100 100 100
-20 80 -20
5 85 5
-10 75 -10
-80 -5 -80
20 15 20
The expected field is Increment. The first is gonna be the same then after the Increment field changes with the the transaction value
I guess you have more then one dimension in your chart... try this
RangeSum(Above(TOTAL Sum(salary), 0, RowNo(TOTAL)))
Both of Sunny's expressions appear to give the correct value...make sure you are sorting salary by Load Order and Original.