Values should differ

[vardhan1305]

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.

[sunny_talwar]

May be try this for increment

RangeSum(Above(Sum(salary), 0, RowNo()))

[vardhan1305]

Hi Sunny

The expression is showing the cumulative difference but isn't showing the resulted value.

[sunny_talwar]

Resulted value? can you elaborate?

[vardhan1305]

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

[sunny_talwar · Accepted solution]

I guess you have more then one dimension in your chart... try this

RangeSum(Above(TOTAL Sum(salary), 0, RowNo(TOTAL)))

[johnca]

Both of Sunny's expressions appear to give the correct value...make sure you are sorting salary by Load Order and Original.