1 Reply Latest reply: Aug 10, 2017 5:39 AM by Morten Braüner RSS

    Average Closing Stock

    Sada Siva

      Hi Team,

       

      I have a formula which will gives me closing stock till max date.

       

      For example i need to calculate Average closing stock  for 100 days. My formula will gives me the stock on 100th days. Is there any way to calculate Day1 closing stock+day2 Closing stock+day 3 closing stock.....till 100th day.

       

      Thanks in advance.

       

      Regards,

      Sadasiva