I’d like to create a lobby element with a field which has no SQL column. The column represents the projected quantity of an item, and can be found in Inventory Part Availability Planning > Availability Check per Day. Ideally, I would use this column to show a list of all items which are projected to have a negative quantity in the next two weeks. However, the column is a calculated aggregate value, where on each date the demand quantity is subtracted and the supply quantity is added.
Is there a way of storing the projected value as a custom field? or perhaps calculating it within a SQL query for a data source?
Thank you in advance.