Hi Community,

I’m working on GI POLines 2.0, where I can see a bunch of relevant data all in one spot.  I’m trying to create a field and formula that will give me a run rate for specific products over a specified date range.  

The data I would need is InventoryID - SUM of QTY on SO’s created during a date range, ideally <@Today-180.  

I’m struggling to figure out the best place to pull the data and/or write a formula where it will SUM the total quantity sold and allow me add date parameters.

Attached is the GI I’ve been using. 

Thanks for the help.  

PS - I am running 2022 R1 Commerce Edition.  I do not have the manufacturing module.