Summary Table returning zeros

I’m trying to make a summary table so that I can get totals for my expenses and income and track my profit. I have combined my sales and purchase log into one table through reference columns, however, when I try to make a summary table from that, all the values come out as zero for some reason. This doesn’t happen if I make a summary table from the original tables the second one references. Any help would be appreciated.

Hi there,

Could you share your document with as OWNER so I can take a closer look?