This content has been marked as final. Show 2 replies
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.