1
2
3
4
5
6
7
8
9
10
11
var fields = [{
    fieldName: "Quantity",
    dataType: "number"
}, {
    fieldName: "UnitPrice",
    dataType: "number"
}, {
    fieldName: "Price",
    dataType: "number",
    calculateExpression: "values['Quantity'] * values['UnitPrice']"
}]

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
var fields = [{
    fieldName: "Quantity",
    dataType: "number"
}, {
    fieldName: "UnitPrice",
    dataType: "number"
}, {
	fieldName: "Price",
	dataType: "number",
	calculateCallback: function (dataRow, fieldName, fieldNames, values) {
	    var quantity = values[fieldNames.indexOf("Quantity")];
	    var unitprice = values[fieldNames.indexOf("UnitPrice")];
	    if (isNaN(quantity) || isNaN(unitprice))
	        return undefined;
	    else
	        return quantity >= 1000 ? Math.round(quantity * unitprice * 0.95) : quantity * unitprice;
	}
}]