Difference between two columns from two different tables

[Beastz99]

I am having a problem with getting the basic difference between two columns from 2 different tables.

I want to find where the discrepency is between the two columns since one has more money in total when it should be matching.

I have a many to one connection on the invoice id each value down below is for a invoice.

[v-binbinyu-msft]

Hi @Beastz99 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu