I have a question that I haven’t been able to figure out nor find an answer to on the internet… so I thought I could ask here and someone may have an answer for me!
I need to calculate the total value of all invoices that contain certain Product ID’s.
Note: Just in case someone jumps the gun, I know how to use the calculate function to find the total value of certain product ID’s. Find below how I can do this.
However this is not what I am after unfortunately. I need the total value of invoices where these Product ID's exist.
If anyone has any idea it would be much appreciated!