5 Replies Latest reply on Aug 14, 2018 12:56 PM by John Lee

    How to calculate % of total sales forecast for month

    John Lee

      Hi, I have daily sales forecast for the month of August 2018. I also have ACTUAL sales until Aug 9th 2018, as you can see in the attachment below.

       

      I want to create a calculation where I can take the running total of the sales forecast until Aug 9th (max date for ACTUAL sales data) and divide it by the total sales forecast number. In addition, when ACTUAL sales data for Aug 10th comes in, I want it to automatically calculate the running total until Aug 10th and divide it by the total forecast number.

       

      Thank you.

       

      Total Forecast for month of Aug 2018:

      ACTUAL up to date sales until Aug 9th 2018: