3 Replies Latest reply on May 26, 2016 12:59 PM by Rohan Malusare

    Show 0 when there is no value

    Tiffany Kinson

      Hello,

       

      I have been trying to have my worksheet show a "0" for Qty Ordered against a forecast in order to drive a forecast attainment metric. However, if there is no Qty Ordered, and there is a forecast, it shows up blank.

      I want there to be a "0" to show up in the Qty Ordered, and the actual forecast to show up in the Final Forecast column.

       

      Does anyone have any advice or experience with this?

       

      Thanks!

      Tiffany