Hi All,
I have an expression which gives me current stock levels. I want to be able to work out how many days stock i have based on the sales of last week (just the one day, so for today i would want the stock days based on last fridays sales.
The calculation i have for the stock level is :
sum([Received Qty])-sum([Qty Purchased])
and i want the stock days based on the sales relating to the variable vtoday-7.
Can anyone help please?>