SQL Help - collect and calculate the sum of unique items in different invoices

[ihayek86]

Hello everyone!

I am working on a project where i give the customers an invoice to buy some items from a store
after a while the seller there bring to me several invoices and here I need to collect them and calculate the quantity of items and put price for every item because the price is different every time and then
calculate the total and assign this big invoice to this supplier.
I have 3 tables
invoice, invoice details, payment invoice(to assign invoices to the payment), (table to make the calculation and payment and to assign it to reseller)

I have problem to do select statement that selects the all unique items in the collected invoices under the payment invoice table. can anyone help with this

[MultiTech]

First, welcome to the community! You might check out the following post, it’s got tons of helpful hints to help you get started.

Guide on How To Create a Community Post Tips & Tricks 💡

Excellent guidance from a senior guide in the community @LeventK. My humble suggestions below: Over the years the AppSheet team and community members have created some excellent reference material. I believe many interesting solutions and excellent help articles and sample apps are available. Whenever a new member joins the community, we anyway get a notification from the community platform. While responding to the first few posts of a new member, we, who have been around in the communit…

---

Inside your app, I hope you’re using references to connect your tables together.

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

If you are, you can easily pull out a list of all the selected items for each invoice by using a list de-reference formula

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

If you wrap that with UNIQUE(), you’ll get a list of each item that has been selected for your invoices.