The issue is, in the 3rd column I have it set to give me the Sum of the column at the bottom. It works on the Google sheet, it works within the plugin itself but will not work on the WordPress site, it just says 0 for the total regardless of what is in the cells.
Column 2 and the last column have the same formula and they work fine and show up on the page on the site. I have recreated everything, I recreated the Google sheet, the import of the table to the plugin and it does the exact same thing.
Can anyone shed some light on what might be causing this?