The result of the following equation
SUM ( SELECT (WAREHOUSE[PRODUCT NAME], [QUANTITY] = [_THISROW].[PRODUCT NAME]))
Does not sum on its own with the inventory table when adding new items in the quantities section.
I noticed that when I press to modify in one row in the inventory table and re-save without any modification, the equation works and shows the result of the sum of the quantities entered in the warehouse
Is there a better way to show the sum quantities in the warehouse without opening the registry, modifying it and closing it?
Attached image example of the tables used and the location of the equation used
(I add quantities to the table, the program doesnโt sum automatically. I have to open register, save and closeโฆso that program update quantities)
Solved! Go to Solution.
Use Sumif
in spreadsheet formula in quantity column of Stock table
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |