3 Replies Latest reply on Aug 13, 2018 11:09 AM by Deepak Rai

    How to only sum forecasts up to present date

    John Lee

      Hi, I have daily forecasted sales data for the month of August (From Aug 1st to Aug 31st)

       

      I want to be able to create a calculated field where I can add forecasted sales value up to the most current date (Aug 13th). How can this be achieved?

       

      I want to add forecasted sales from Aug 1st, 2nd, 3rd, 4th ....... all the way up to the most recent date. I also want this to update automatically tmr. Thank you