5 Replies Latest reply on Jul 24, 2018 5:34 AM by Bill W

    Combining two rows into one to return values

    Bill W

      Afternoon Tableau Friends,


      I'm straggle with what appears to be a simple calculations however its not working.


      What I am trying to do is show the Actual values YTD until it hits a null value / 0 value and then return the Forecast values where those are null.


      Per my attachment I would like to fill-in August - December with Forecast Values.


      These are a few of the calculations I came up with.


      If [Actuals/Forecast] = "Actuals" and [Total HC] > 0

      then [Total HC]


      if [Actuals/Forecast] = "Forecast" then [Total HC] END


      Tried using a Fixed LOD function but that ended up added everything together.