Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

work out how many days of stock.

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?>

0 Replies