First time post, long time viewer.
Hey everyone, I've been getting advice from you great people for awhile, but now I have an issue that's a little more specific to my environment. I have an inventory system which has about 60k parts in it. My goal here is I'm trying to show a sum of the running total of part quantity on hand, with the addition of purchase orders and the subtraction of sales orders related to these parts. I'm trying to put this into a line chart, with the ReqDate as the dimension, so I can see when inventory is going up and down.
It may be a little easier if I explain like this:
Partno Qty -(This is loading on hand amount in system)
SalesOrder Partno Qty ReqDate -(Date Qty will be subtracted from Running Total)
1 A 10 1/22/2017
2 B 5 1/17/2017
3 C 20 2/03/2017
PurchaseOrder Partno Qty ReqDate -(Date Qty will be Added to Running Total)
1 A 5 2/14/2017
2 B 15 2/05/2017
3 C 25 3/12/2017
Now obviously my data is on a much bigger scale, but the premise is mostly the same. I believe I have an issue with there being no ReqDate associated when I load the Table1_OH. I've tried load Date(today()) as reqdate on that table and using RangeSum function in line chart, but then the on hand sums go whacky on dates where Sales Orders or Purchase Orders hit the system.
Sorry guys, I know this is lengthy. I can upload a sample of what I've got if anyone needs.
Thanks in advance!