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

    Simple Rangesum struggle

    Anat Dagan


      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?