Flag the records the value of which sums up to zero in two files

[45179902]

I have a dataset like this coming from two data files:

ID	Amount	File
2023-01	5000	A
2023-02	2000	A
2023-01	-5000	B
2023-02	-5000	B

The ID column are primary keys that indicate an item in the file. 

What I want Alteryx to do is to filter out the items the amount of which sums up to 0 in the two files A and B. The output; therefore, should be something like this

ID	Amount	File	Flag
2023-01	5000	A	Yes
2023-02	2000	A	No
2023-01	-5000	B	Yes
2023-02	-5000	B	No

I have tried Summarize and Filter tools, but I just can't get this desired output. Please help out Alteryxers!

[geraldo]

@45179902 

An workflow example: