2 Replies Latest reply on May 23, 2018 6:02 AM by NAVYA KARNATI

    Calculation for Bar Chart that hides certain bars after certain month

    Aileen Rotondo

      Hello,

       

      I am trying to make the YTD Actuals for TODAY()s month = 0 and every future month = 0 WITHOUT changing the data from the prior months.

       

       

       

      The calculation I'm working on...

      Hide YTD Actuals ---

      IF [Month] < INT(MONTH(TODAY())) THEN [Actuals] ELSE 0 END  (See below)

       

      It sort of works, it hides the bars I want to hide, but then the "YTD actuals" change because I don't know how to put a SUM in my calculation without getting an error.