Hello All,
I am needing some help in trying to run a calculation across two separate lists in the same sharepoint
In List "A" I have a column that is storing a number value in quantity as to what is available for use or consumption.
In this same list in a different column, I also have a safety stock which is also storing a number. Right now, if the quantity value is less than or equal to the safety stock value then a YES/NO is triggered in a different column for a re-order.
All of this is working as intended, where I am having the issue is trying to keep a running total when a certain number(s) of a particular item(s) are being used or consumed.
I have created List "B" which has a part look up that is retrieving information from List "A"
Right now, in List "B" I can look up a part number and its quantity available for use. What I have done is added a new column for quantity used or consumed and I would like this to be a calculation based on other columns in List "A"
Essentially what I want to be able to do is in List "B" in the column "quantity used" and have that value be subtracted from List "A" in column "quantity available for use"
If anyone can help me with this or even let me know if this is possible or even if there is a better way of doing this, I would be very humbled and appreciative of the help.
Thank you for your time and I look forward to your response.
