Inventory Turnover Calculation

Inventory Turnover Calculation

My Creator experience is very limited, but I have created an Inventory Management database and input data using the form "File Input Form".  The important fields for this discussion would be "Warehouse Arrival Date", "Consumed Date" and "Status of Inventory".

I am trying to figure out how to get Creator to calculate inventory turnover for me with the data in the database.

I would need a form or report that would take 2 user designated fields; "Begin Date" and "End Date" and perform the following.

Inventory Turnover = ("Consumed Date" range "Begin Date" to "End Date") /   ((if "Warehouse Arrival Date" before "Begin Date" & "Consumed Date" after "Begin Date" OR "Status of Inventory" equals "In Warehouse") + ( if "Warehouse Arrival Date" before "End Date" &  "Status of  Inventory" equals  "In  Warehouse" OR  "Consumed Date" after "End Date"   / 2)

I hope that make sense, I'm kind of tired of thinking about it and hoping someone can help with that.

Thanks