Help with product stock sum

Hello,
I’m trying to build an inventory system. There may be lines in the database with the same name with different values.
for example:
shoes: +3,
shoes: -1.
I would like to only show the name once in a repeating group with the result of the sum of all entries for a single name.

This is the current page:

as you can see, there are rows with same description. I would like to show only 1 row with the sum of “Estoque atual”.

Can someone help me?
Thanks in advance

Hello,
In your “Do a Search for”, try to use “Group by” and then aggregate the results by the Sum.

Hope this helps !

1 Like