So I am working on an Inventory Management System that records purchase cost, stock available, value of each item and value of total inventory. I used the Inventory Management System Template and modified it to my needs.
However the problem arises in calculating the cumulative value of the whole inventory. Current stock available and value of each item in stock are calculated through virtual columns. When I tried to create a virtual column for total inventory value it didnt work as it goes row by row, and my research shows that app sheet currently does not have the ability to aggregrate sum of rows into one.
I came up with the idea to convert the virtual column into real column by copying it into another table on source through actions and automations, and use a button to trigger this whenever total value is required, but I am struggling alot in converting virtual column to real column and also getting teh formula and expressions right in the actions and workflow since I am a newbie and this is my first ever app.
I would appreciate help in resolving this issue my helping me in execute my idea or telling me another way to calculate the cumulative value of my inventory as the goal is to achieve this!!!
Thankyou and please help me out, this app is really important
LinkedIn
Twitter
