2 Replies Latest reply on Jun 28, 2016 1:04 PM by Tejal Narkar

    Calculating Grand Total at the end of waterfall chart

    Tejal Narkar

      Hi Guys, I am trying to

      I am trying to build a waterfall model for the first time. I am struggling to get the final total. The total that I am getting is the sum of the rows(screenshot pasted below).

      Whereas the total that I should be getting should be 8.

      The data looks like below screenshot.

       

      The formula that I used for calculating headcount is:

      IF ATTR([Action])="Seperation" THEN -1*COUNTD([Employee ID])

      ELSE COUNTD([Employee ID]) END