Simple Rangesum struggle

[Anonymous]

Hi,

I am trying to create a rangesum to add up values in the sum(inc/pay Amnt) column while having 2 dimensions in the table - date and name (table is displayed right to left).

I am using the following formula

rangesum(above(Total Sum([Inc/Pay Amnt])),0,rowno(total))

but it seems to :

sum up the row numbers

not add up the values correctly.

what am in doing wrong?

[swuehl · Accepted solution]

I think it just about the correct placement of the parentheses, try

rangesum(above(Total Sum([Inc/Pay Amnt]) ,0, rowno(total) ))

[Anonymous]

Thanks! it worked!