2 Replies Latest reply: Sep 11, 2017 11:21 AM by Lewis Jackson RSS

    Sum a rangesum

    Lewis Jackson

      Hi, would someone be able to explain how I would be able to do a sum on the following?:

       

      Rangesum(Above(TOTAL Sum(column1)-sum(column2),0,rowno(TOTAL)))

       

      I'm needing to put the sum of the above into a KPI field.

       

      Would someone be able to help me out? Cheers