1 Reply Latest reply on Aug 8, 2018 12:35 PM by Deepak Rai

    How to compute the % of sales vs forecast

    Josh Williams

      Hi, I have both MTD sales and monthly forecast data. They both have filters as you see below in order to be able to select and view any date on the list.

       

      Now, I want to be able to divide MTD sales number by monthly forecast number to show how we are doing compared to forecast in terms of %. How can I create this calculation and also be able to show previous comparisons? So for example, if I want to see the percentage of past July 2018 MTD sales vs July 2018 monthly forecast, can I create a filter to do so. Thank you

       

      MTD sales:

       

       

      Monthly forecast: