Inventory Management System-Virtual to Real Column to calculate total value

[mbz257]

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

[Tommy62]

Könnten Sie einen Link angeben, um welche Vorlage es sich genau handelt?

Zunächst einmal eine Anleitung für die Konvertierung --> Konvertieren einer virtuellen Spalte in eine reale Spalte 

[mbz257]

Hello, I have tried this, but the values dont copy so its not working

[AleksiAlkio]

May I ask why do you think it's not possible to calculate the total inventory with VC? Though if you do it, it will show the same value for each row. Would it be better to calcualte it another table so it would need to do it only for one row?

[mbz257]

Maybe I am messing with the expression, so if you could help with that. For Context purchase cost is a column in table " items", Total Stock Available is VC in table items that records available stock of each item and value of each is a virtual column in table item that records value of each item. If you could help with the expression with this information, it would be great

[Tommy62]

Davon ausgehend, dass Ihre VC-Spalte [Artikelwert] den Inventarwert des einzelnen Artikels berechnet, dann probiere doch mal den den einfachen SUM-Ausdruck-->

SUM(Artikel[VC_Wert_Artikel?])

[mbz257]

My first try was to do this, but I was unable to do so and when I searched online, some websites said aggregating isn't possible. If you could provide a way to to do this I am more than happy to implement as having same value on each row doesn't matter.

I

[MarcosDuque]

Hi there.
You found a solution to your problem?
I trying the same here too.

[MarcosDuque]

Hi there,

You found a solution to your problem?