2 Replies Latest reply on Jul 12, 2018 2:12 PM by Riaz Khan

    Hiding percentages on null values

    Riaz Khan

      Hello

       

       

      I have four columns. In the first column is a running sum that takes data and does running total. The formula is

       

      Current Week DN Drop

      IF([Rptg Rolling Week]) = 0

      THEN

      [DN Drop Qty]

      END

       

      It shows data for every day, but there is no actual quantity in Thu-Sat so the number 595 repeats itself. In the second column I wanted the blank ones removed so I used this calculation

       

      Current Week DN Drop - Nulls

      IF NOT ISNULL(SUM([Current Week DN Drop]))

      THEN RUNNING_SUM(SUM([Current Week DN Drop]))

      END

       

      Now I am trying to get the last column to show the percentage but not show the ones that should be blank like column 2 for Thu-Sat. So the 58.47% should only show for Wed and everything after that would be blank. The formula I am using is

       

      % difference

      (RUNNING_SUM(SUM([Current Week DN Drop])) / [MAX Current Week Forecast])

       

      I thought fixing this would be as simple as changing out Current Week DN Drop with Current Week DN Drop - Nulls so

       

      (RUNNING_SUM(SUM([Current Week DN Drop - Nulls])) / [MAX Current Week Forecast])

       

      but it's not working.

       

      Any help would be appreciated and thanks in advance.