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.

       

      Thx

      -Bill