4 Replies Latest reply on Apr 28, 2017 12:14 AM by Norbert Maijoor

    Need to exclude incomplete current month actuals on a Dual Axis Line graph

    Will Davis

      I have a dual axis line graph with Actuals (with a line representing current year and prior year) and current year budget.  The data is by month, so when a month is incomplete the line has a sloping effect that completely skews the graph.

       

      What formula can i use to exclude incomplete month/most current month? 

       

      I've searched and searched but can't seem to get a formula to help with this particular instance.

       

      Thanks in advance!!