7 Replies Latest reply: Mar 11, 2015 10:44 PM by anbu cheliyan RSS

    Accumulation - include first row in totals

      Hi,

       

      I'm having an issue with my accumulation function. I need it to include the value on the first row as well. Below is the output I am currently experiencing, however what I was expecting to see is in the "Running Total" column - 75.73% on the first row and the subsequent values adding on top of the initial value. Any assistance would be greatly appreciated.

       

      Here is how the columns are being calculated:

       

      Relative Total: sum(count) WITH relative option selected

      Total Count: sum(count) WITHOUT relative option selected

      Running Total: Above(TOTAL Column(1)) + If(Above(TOTAL Column(3)) > 0, Above(TOTAL Column(3)), 0)