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

# How to calculate % of total sales forecast for month

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:

• ###### 1. Re: How to calculate % of total sales forecast for month

Hi John,

Left Outer Join on date Field

Create a calculated field like below

Final Result:

6.09/29.31=0.2077

Hope this helps

Kindly mark this as helpful or correct so that it will help others

Check the below  TWB and attach the files like i mentioned above

BR,

NB

• ###### 2. Re: How to calculate % of total sales forecast for month

Hey, sorry for asking again, but I am trying to take the running sum of forecasted sales until Aug 9th 2018 (which is the most current up to date) and divide it by the total forecasted sales for August.

Is there a way to achieve this?

Thank you

• ###### 3. Re: How to calculate % of total sales forecast for month

Hi John,

Create a calculation like below and apply last=0 filter

Attached the workbook for the same

Hope this helps kindly  mark this answer as correct/helpful so that it will help others

BR,

NB

• ###### 4. Re: How to calculate % of total sales forecast for month

Hey, I tried it but it still doesnt work even on the example workbook that you uploaded, can you please explain again? Thank you so much

• ###### 5. Re: How to calculate % of total sales forecast for month

I am so sorry to bother you again, but can you try again with the new data below: