Hi,

In the @denis chenu's plugin GetStatInSurvey, add this code in GetstatInSurvey.php:

On line 221

case 'sumnum':
switch ($oQuestion->type) {
case "5":
case "L":
case "!":
case "O":
case "N":
case "*":
case "S":
return $this->getSumNumeric($this->iSurveyId."X".$oQuestion->gid."X".$oQuestion->qid, $sValue);
default:
return $this->_logUsage("{$sMatch} : Invalid question type : {$oQuestion->type} in {$this->sDebugWhere}");
}
break;

And, add this private function in GetstatInSurvey.php too:

/**
 * Get the sum for a numeric question type
 * @param : $sCode : question title
 */
private function getSumNumeric($sColumn,$sType="sumnum")
{
    $aSumNumeric=array(); // Go to cache ?
    if(isset($aSumNumeric[$sColumn]))
        return $aSumNumeric[$sColumn];
    $sQuotedColumn=Yii::app()->db->quoteColumnName($sColumn);
    $iTotal=$this->getCountNumeric($sColumn);
    $oCriteria = new CDbCriteria;
    $oCriteria->select="SUM({$sQuotedColumn})";
    $oCriteria->condition="submitdate IS NOT NULL";
    $oCriteria->addCondition("concat('',{$sQuotedColumn} * 1) = {$sQuotedColumn}");
    $iSum = Yii::app()->db->getCommandBuilder()->createFindCommand(SurveyDynamic::model($this->iSurveyId)->getTableSchema(),$oCriteria)->queryScalar();

    if($iSum > 0){
        $aSumNumeric[$sColumn]=round($iSum);
    } else {
        $aSumNumeric[$sColumn]="";
    }
    return $aSumNumeric[$sColumn];
}   

It work on a V6.5.4 limesurveyVersion

ping @tibor.pacalat

OK for a Pull Request ?

@DenisChenu not sure what you mean

@tibor.pacalat : Did LimeSurvey GMBH are OK to have such feature in core plugin ? If yes : @jbarrouillet can prepare the Pull Request and i can review on github.

https://github.com/LimeSurvey/LimeSurvey/blob/master/CONTRIBUTING.md#submitting-changes

@DenisChenu yeah we can include this in core plugins, but it needs to have unit tests etc.

@jbarrouillet : can you create a PR please ? I add the unit test on it after.

Hi @DenisChenu, yes i can, but i'm a newbe and i don't know what is a PR and how to create it.

@DenisChenu. PR --> Pull Request OK, I understand and i saw this option in gitub.com/Limesurvey project. I'm trying to move forward on this and be more efficient. :-)

Sorry … unclear here :)

See https://docs.github.com/en/pull-requests/collaborating-with-pull-requests/proposing-changes-to-your-work-with-pull-requests/creating-a-pull-request