Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I think it just about the correct placement of the parentheses, try
rangesum(above(Total Sum([Inc/Pay Amnt]) ,0, rowno(total) ))
I think it just about the correct placement of the parentheses, try
rangesum(above(Total Sum([Inc/Pay Amnt]) ,0, rowno(total) ))
Thanks! it worked!