1 Reply Latest reply on Jun 7, 2018 6:45 AM by Joe Macari

    Table calculation difference, eliminate outliers.

    Diogo Braga

      I have a table calculation calculating the weekly difference between current commitments in 2 academic years, it looks like this:

       

      SUM([Current Commitment (Weekly)]) - LOOKUP(ZN(SUM([Current Commitment (Weekly)])), -1)

       

      The issue when current commitment is 0, this happens twice in Week 20 when there is simply no data in 2017-2018 to compare, and the upcoming week since the data is not available yet.


      I could just hide the outlier week, but I would rather change the calculation so these long bar graphs don't show. How can I do that?

       

      2018-06-07_0901.png