2 Replies Latest reply: Mar 30, 2017 10:44 AM by Matthew Davies RSS

    Development Triangle

    Matthew Davies

      All,

       

      Was hoping someone would be able to help me with a pivot chart issue i am having.

       

      Little background, I'm trying to show the "ultimate" value of the customer after they've received all their deductions to see how much is left. Basically a running total.

       

      Data

        

      DayNet Paid
      01201
      96000
      105410
      11-201
      12280
      13-2898
      16-1000
      18710
      24-3875
      255
      26-109.25

       

      The end value of the customer is 5522.75 and i am trying to show this horizontally in a pivot with a cyclical group going vertically.

       

      using the below formula my end result is incorrect at -109.25

       

      =rangesum(above(sum(Claim_Incurred),0,rowno()))

       

      Does anyone have any suggestions?