2 Replies Latest reply: Aug 19, 2017 11:30 AM by Anat Dagan RSS

    Simple Rangesum struggle

    Anat Dagan

      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?