Hello KienbaumIT.

I'd like to know if you're going to calculate any averages in that column?

If not - this should be easily fixable. When you click on column settings, go to Conditional Formatting. There you can enter a rule:

So, when a 0 is found in the cell, it'll just lose it and display a blank cell:

 Or, you can add a dash, like this:

So it looks like this:

Basically, this only impacts the AVG and MIN calculation of the column; SUM and MAX will still remain unchanged.

I hope this helps.

Best regards.

Hello again KienbaumIT.

It took some time, but I believe we found a temporary solution for you. Please note that this hasn't been thoroughly tested, so I can't guarantee that it'll work in all instances.

Please open ../wp-content/wpdatatables/controllers/wdt-ajax-actions.php and search for this around line 357:

$formData[$column->orig_header] = WDTTools::wrapQuotes((float)$formData[$column->orig_header], $tableData->connection);
   if ($formData[$column->orig_header] == '') {
   $formData[$column->orig_header] = NULL;
   }
   break;
 case 'int':
   $formData[$column->orig_header] = WDTTools::wrapQuotes((int)$formData[$column->orig_header], $tableData->connection);
   if ($formData[$column->orig_header] == '') {
   $formData[$column->orig_header] = NULL;
}

Please delete "(float)" and "(int)" so it looks like this:

$formData[$column->orig_header] = WDTTools::wrapQuotes($formData[$column->orig_header], $tableData->connection);
   if ($formData[$column->orig_header] == '') {
   $formData[$column->orig_header] = NULL;
   }
   break;
 case 'int':
   $formData[$column->orig_header] = WDTTools::wrapQuotes($formData[$column->orig_header], $tableData->connection);
   if ($formData[$column->orig_header] == '') {
   $formData[$column->orig_header] = NULL;
}

That should keep the empty values without adding the zero there.

Please try this and let me know if it helps.

Best regards.

Hi again Florian.

I don't know if it will be implemented in the next update, but it most definitely will in one of the future ones. One of our developers has started working on an even better solution for it, so it should be an included feature in the future.

Until then, please save this reply because you will need to do it again if it's not included in the next update.

Best regards.