AnsweredAssumed Answered

Calculating current stock depletion rate

Question asked by vitalseeds on Dec 20, 2018
Latest reply on Dec 21, 2018 by vitalseeds

Hi Filemakers


I run an online store and am trying to figure out a way of predicting stock depletion. I have all of my data for each stock sale in a Line Items table which has dates on it.

What i need is to calculate the number of items sold in the last period of time (week, month etc.) so i can then estimate when my stock will run out. My business is very seasonal (seeds) so the rates will change over the course of the year which is why i need to be able to calculate the current rate.

Any ideas?!