5 Replies Latest reply on May 13, 2013 4:23 PM by Siddharth Surana

    Adjust the forecast Amount based on how much was delivered the previous day

    Siddharth Surana

      Hey Tab Gurus


      I have a simple yet effective requirement. I have a Column that records the amount ordered to be delivered and the forecast of that order. Now in real life, you do not deliver exactly what was forecasted and hence the forecast for the remaining days change. I would like to ask if someone can come up with a calculated field that does that for me. Also, Can i know how I can have a filter that defaults to the current date everytime the user logs in the morning to check his forecast for the day and week.


      PFA the Excel Sheet. The first sheet is the ideal scenario and the second is a sample of the actual recorded data and the 'Forecast for the day' is the desired field.


      Hope its clear and some of you may shine light onto this question