Help w/ Advanced Inventory Menager based app

Hi, first of all, I am not an expert on development or programming, I really need your help on this, and I do not speak english that well too, so be patience.
I have this aplication based on the sample app " Advanced Inventory Menager", the app has two columns, “Inventory Change Log” and “Total Stock Available”, the thing is, when i add a new product to the stock, it always add up to total stock, and for what I’m building here I want to register all the changes in the Log, but need to show only the last amount of the product registered on the Total Stock Available.
For you guys to undestand better, I’m buildind an app to menage the amount of Gasoline and Diesel we have available on our Gas Station.
I’m putting some images of the aplication and hope you can undestand what I need here.
My main language is Portuguese, so the app is in PT-BR.
https://imgur.com/8q86q1A
On this fist image you can see a total stock of 23.000L of gasoline, but a need it to show it only the last amount registered. And the second image you can see the inventory change log and it’s perfect, i just need to get the last value to put it on the total stock, here you guys can see 3000 as the last amount…
The app is adding up all the values to the Total Stock Available.
Now images from the code:
Total Stock Available formula.
https://imgur.com/h5OlP5R
So, hope someone can help me with this…
If you need more information about someting specific just tell me.

1 Like

Perfect, Steve! That was exactly what I was looking for, it works perfect now!
Thanks a lot!

1 Like