I have two separate Sharepoint lists. List A carries all the invoice information, and has an Order ID that is unique to the deliverable. This list can have multiple invoice amounts per deliverable:
Example Sheet A:
List B carries all of the invoice information, but also has the same Order ID that matches to List A.
Example Sheet B:
My goal is to sum all invoice amounts per Order ID from List A, and print it to the Total Amount column in List B by the same Order ID.
Ideally each deliverable in List B would have the corresponding invoice totals showing up in the Total Invoice column of List B.
I have been trying for a few days and struggling to find the solution, any help would be greatly appreciated.
There was this exact question posted a long time ago, but the images have since expired which makes it very difficult to understand the solution.
You need to do a GroupBy with an Add Column, with the expression for summing the grouped Column.
Its late, wanted to toss that out and will be back tomorrow if you need more help.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
6
Share
Report
All responses (
Answers (
