Hello, Todd.

Sorry for the delayed response.

- To remove the SUM/Total symbol, you need to open and edit a little bit of code from three files using any text editor of your choice; find them inside your WordPress folder :

- The PHP file :

../wp-content/plugins/wpdatatables/controllers/wdt_functions.php

use "CTRL+F"  in the editor to search for this: " #8721 "

You will find part of a line that looks like this :

echo ((isset($wdtSumFunctionsLabel) && $wdtSumFunctionsLabel != '') ? $wdtSumFunctionsLabel : '& #8721; = ')

- Remove "& #8721; = " from the end, so it looks like this:

echo ((isset($wdtSumFunctionsLabel) && $wdtSumFunctionsLabel != '') ? $wdtSumFunctionsLabel : ' ')

- Do the same for this Javascript file, 

which is located here : 

/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js

you will find something like this :

var sumLabel = tableDescription.sumFunctionsLabel ? tableDescription.sumFunctionsLabel : '& #8721; = ';

Once "& #8721; = "  is removed, should look like this :

var sumLabel = tableDescription.sumFunctionsLabel ? tableDescription.sumFunctionsLabel : ' ';

- Same with this PHP file :

wp-content/plugins/wpdatatables/templates/frontend/table_footer.inc.php

;

Once you are finished, the SUM/Total symbol should be gone from the Front End.

Also, make sure to disable "Use minified wpDataTables Javascript" slider in the wpDataTables settings/Custom JS and CSS tab, as on this screenshot :

;

 2.

• For the Average symbol/prefix; it should be the same, they are all close to each other in the code; as you can see here as (   'Avg =';    )

- I will double-check with the developers and get right back to you when they respond, just to be sure; but in my opinion, it should be safe for you to try the same with the "Average prefix" in the meantime if you make a copy of all three files : (

../wp-content/plugins/wpdatatables/controllers/wdt_functions.php

/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js

wp-content/plugins/wpdatatables/templates/frontend/table_footer.inc.php

)

That way, even if a mistake happens, you would have a backup to revert to. So, you can give it a go if you wish, and in the meantime, I will double-check and get back to you as well.

Hello again, Todd

Apologies for another late response.

- That is correct, during update time, all the core/code files are deleted, and rewritten to "default lines", so you would have to do this process again to remove any symbols that you need to.

- I confirmed it should be the same procedure for "SUM, Average, or MIN" removal of the prefixes.

- Regarding moving the files into a child theme, the information I have is that this would not be possible/ but I will double-check that as well and will post back just to confirm additionally.

Hi, Tod.

- We have additional information that might be very useful; depending on how you would like to insert the calculation functions on the WP page(s).

- Editing those 3 files I showed you is one way of doing this; this is necessary if you need to use the SUM / Average, or Min as part of the table, with the box checked on the column settings;

but in case you use a shortcode - you don't have to edit those 3 files, and this will not be deleted during updates;

what you would do is add parameter "label" at the end of the Calculation shortcode, and put an empty value in it, like this:

[wpdatatable_sum table_id=1 col_id=10 label='']
[wpdatatable_avg table_id=1 col_id=10 label='']
[wpdatatable_min table_id=1 col_id=10 label='']
[wpdatatable_max table_id=1 col_id=10 label='']

( Of course, replace the 'table_id', and 'col_id' with the respective values for your table/column).

Additional note: you can set a custom label for functions, if needed, in the main settings of the wpDataTables plugin from the WP Admin Dashboard -

Hopefully, this information should make it easier for you to use this functionality. If you need more details, please contact us further.

Hi, Todd

- I experimented with adding Average shortcode to a test WP page; and when I added this custom CSS to the WP page , it  has made the shortcode stay on the same line as the % sign;

.wdt-column-avg {   
 display: inline-block;
}

If that doesn't work, could you give me a link to the page where you put this shortcode, so that I can take a closer look? I have an idea what to do, possibly with some custom CSS added to the page; but not sure yet.

And if you want to save time, I could access the page editor in your WP Admin, to try and directly test a solution; if you provide me a temporary WP-admin (administrator) user 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 parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.