I have 2 tables
Current stock table
Name Article (Enumlist)
Code Article (Ref )
Quantité (Number)
EntryOut table
Current stock table
Name Article (Enumlist)
Code Article (Ref )
ID (UNIQUEID)
Quantité (Number)
I want to do the sum of the quantity of every article in table EntryOut and report it to the column quantity=current stock of every article
I did SUM ( SELECT (EntryOut[Quantité]; [Code Article]=[_THISROW].[Code Article] )) but it don’t work and i tried also this formula
SUM ( SELECT (EntryOut[Quantité]; [Code Article]=[_THISROW].[Code Article]))
Don’t work also…
Who can hepl me
I think you should check out references
When you connect tables together, they’ll create what’s called a “reverse reference” - from these you can easily list dereference the totals
SUM([Related EntryOuts][Quantité])
Yes , i try it but appsheet warns me that it does not recognize the related column…
It work when i test the formula but the quantity wasn"t shown… how can i do ?
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |