Amount of days in inventory

[#1]

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

[#2]

any ideas?

[#3 · Accepted solution]

Solved.

See the example in attachment.

regards,

Raf