2 Replies Latest reply: Jul 3, 2013 9:17 AM by Raf Verbruggen RSS

    Amount of days in inventory

      Hi experts,

       

      I would like to make a bar chart which displays the amount of days that it will take for a stock unit to be completed. But I can't find the formula.

      Data is on monthly basis.For the last month, the forecast can be devided by 30 to get the average to calculate the days.

      I have a measure [stock begin month] and for each month a [forecast of stock sold] measure.

      This with month as a dimension.

       

      What is the best way to do this? With a loop in the script?

       

      Thanks in advance,

      Raf