Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Simple Rangesum struggle

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?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

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

Anonymous
Not applicable
Author

Thanks! it worked!