Dynamics CRM JavaScript平均值

// 获取实体记录中的数值字段值
function getNumberFieldValue(entityName, fieldName) {
    var fieldValue = Xrm.Page.getAttribute(fieldName).getValue();
    return fieldValue;
}

// 计算平均值
function calculateAverage(entityName, fieldName) {
    var records = Xrm.Page.getControl(entityName).getGrid().getRows().get();
    var total = 0;
    var count = 0;

    for (var i = 0; i < records.length; i++) {
        var fieldValue = getNumberFieldValue(entityName, fieldName);
        if (fieldValue) {
            total += fieldValue;
            count++;
        }
    }

    var average = total / count;
    return average;
}