In attempt to render the "Avg" of a specific column in a wpdatatable, the webpage returns a 

Warning: Division by zero in /var/www/html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php on line 1459

This is the entire block of code in the pointed plugin file:

 public function calcColumnFunction($columnKey, $function) {
        $result = null;
        if ($function == 'sum' || $function == 'avg') {
            foreach ($this->getDataRows() as $wdtRowDataArr) {
                $result += $wdtRowDataArr[$columnKey];
            }

            if ($function == 'avg') {
                $result = $result / count($this->getDataRows()); (this is line 1459)

                require_once(WDT_ROOT_PATH . 'source/class.float.wpdatacolumn.php');
                $floatCol = new FloatWDTColumn();
                $floatCol->setParentTable($this);
                return $floatCol->prepareCellOutput($result);
            }

        } else if ($function == 'min') {
            foreach ($this->getDataRows() as $wdtRowDataArr) {
                if (!isset($result) || $wdtRowDataArr[$columnKey] < $result) {
                    $result = $wdtRowDataArr[$columnKey];
                }
            }
        } else if ($function == 'max') {
            foreach ($this->getDataRows() as $wdtRowDataArr) {
                if (!isset($result) || $wdtRowDataArr[$columnKey] > $result) {
                    $result = $wdtRowDataArr[$columnKey];
                }
            }
        }

        return $this->returnCellValue($result, $columnKey);

    }

Hi Blazenka,

Thanks for the update - I will take a look at the wp-config.php file and make the adjustments you suggested. Please leave this ticket open until it's confirmed the issue has been resolved.

Appreciate your assistance on this.

Thanks

- Brian

Hi Blazenka,

Thank you for your patience - I went ahead and did as you suggested disabling the debugging line item in the wp-config file but it didn't really resolve the main issue which gets me thinking if this is a plugin bug?

Reason why I say this is because for the function "SUM" for the same line-items in the wpdatatable (no entries), the return value is 0 as it should be. But on the "AVG" function, it returned that Warning as screen-shotted initially in this case. After disabling the debugging code in wp-config file, it now returns "nan" on the front end; it used to return 0. 

Can we further investigate this? Flagging incase this may affect other users of this plugin.

ps. The debugging enabled actually may be necessary to help identify issues on the site - this is what pointed me towards the right direction to resolve the PHP XML issue and lead me to submit this support ticket with you guys.

Thanks

-Brian