Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Match Multiple Columns and rollup value of third

Topic Labels: Base design
2159 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Berat
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Everyone,

I spent the entire morning trying to figure this out but apparently it’s not possible.

We have a supplier who sends us multiple packing lists per order. each packing list is basically a box with tracking number.

Please check out this example base:

What we’re trying to achieve, is to rollup the Quantity per each product per order in 1 line.

So the only way to do this is to get all the rows that match order number & product number, then rollup their quantities.

Thank you in advance.

4 Replies 4
Berat
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m still hoping someone would be able to help with this.

Hi Berat,

Sorry that you haven’t had a response. Just so I totally understand the problem, you are looking to sum the quantity of each product for each order? Something like this:

  • Order 1 - Product 1: 25
  • Order 1 - Product 2: 25
  • Order 2 - Product 3: 30
  • Order 2 - Product 4: 35

Let me know if I have the right idea.

Chris

Hi @Christopher_Williams

Thank you for your response.

That’s exactly what i’m trying to achieve in the “Products Per Order” table.

Hi @Berat,

Try this…

Create a field in your Products table to rollup the Qty from Orders
image

Then, change your field in Products per Order table to a lookup bringing the rollup qty into this table.
image

Let me know what you think.
Chris