Need help with tables by supsystic plugin

[ssentner]

Hi,

I am using a plugin called Tables by Supsystic that imports a google sheet onto our wordpress site.

The site is http://t5w.40e.myftpupload.com

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.  Since it works in Google Sheets and also works in the plugin I am figuring there is something wrong with the Wordpress site.

Can anyone shed some light on what might be causing this?

Thanks 

[PL281 · Accepted solution]

@ssentner 

I've not worked with this plugin, however my recommendation is to reach out to the plugin author for support as if it is working in the admin but not in the front end of the site that suggests there is something in their code not passing the code to do the calculation or not doing the calculation before displaying the table.

Generally unless you setup a form with logic / scripting - you generally can't have something dynamic like that - you need some underlying script to do the calculation