Hello Twsears.

Thank you for your purchase.

I am sorry to disappoint you, but unfortunately this cannot be done with the plugin's built in features.

If you are creating an SQL query based table, there is a way of doing this, though, but not in this way.

You'd create the two columns (formula_1 and formula_2) in PHPMyAdmin, and use the SQL code to calculate the sum in the rows.

You can take a look at this simple example in stackoverflow and see how it can be done. Then, when you create the table in wpDataTables using the newly created SQL table, where the rows are already summed, you can use the SUM, AVG, MIN and MAX functions for INT and FLOAT columns and get the desired result.

To display it in a separate table, like in your screenshot, you'd just need to add the shortcode of the SUM in the field, and that's it.

Please let me know if this helps.

Best regards.

You are welcome Twsears. Glad I could help.

If you have any more issues or questions feel free to open a new ticket, we will gladly help.

Best regards.

Hi again Twsears.

I am not sure why it's not refreshing the sum after you apply filters.

Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Best regards.

Hello again Twsears.

I'm guessing you're referring to [wpdatatable id=21] and [wpdatatable id=22], correct?

Could you tell me how you're filtering these two tables? Where and how can I replicate the issue?

Best regards.

Hi Twsears.

I went in and saw that. I changed the query to be:

SELECT formula_1
FROM wp_wpdatatable_5_1_1

Then I changed the name of the column in its settings to "total_3". Even with your original query, it works when server-side-processing is turned off.

Unfortunately, issues like this are always possible with SQL query based tables and numbers. It appears that when you add "as total_3" is when the error comes up. Would it be possible for you to use the query I left in your table?

Best regards.

Hello Twsears.

Which tables are you referring to? I see there is [wpdatatable id=26] on the top of this page:

https://www.travelwithsears.com/accounting/

But when I open that table in the back-end, I see there are no configured formulas for "formula_1", "formula_2" and "formula_3" columns.

Could you please explain in a bit more detail what should be showing, and where? Also, it would be very helpful if you could provide some screenshots of what you need.

Best regards.