Sum in my inventory app

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

0 3 218
3 REPLIES 3

MultiTech
Participant V

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 ?

Top Labels in this Space