Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

agdgn123
New Contributor III

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
MVP
MVP

Re: Simple Rangesum struggle

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

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

2 Replies
MVP
MVP

Re: Simple Rangesum struggle

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

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

agdgn123
New Contributor III

Re: Simple Rangesum struggle

Thanks! it worked!