6 Replies Latest reply on Nov 8, 2018 9:27 AM by John Rivett

    Conditional Running Calculation – 10.4 version

    John Rivett

      Conditional Running Calculation – 10.4 version

       

      I have a running count of quarterly actuals to quarterly targets. In the attached example there are 128 actuals for Q1 and 2 for Q2; the running count shows 130 for Q2, which is correct, but replicates along Q3 and Q4. Since Q3 and Q4 have no actual data, I want the running count to stop at Q2.

       

      I’ve tried this formula but it completely takes out all the actuals:

       

      if attr([Min(Date Of Record)]) <= today() then
      RUNNING_SUM(COUNT([Donor Ids]))
      end

       

      If anyone has a suggestion I would appreciate it much.