var
_totalValue = 0.0;
_totalColumn = 6;
// Specify total number of columns in list view.
_columnIndex = 6;
// Specify the index of the column where you want to display sum values. (i.e. index for first column = 1)
(
function
() {
calculatedFieldCtx = {};
calculatedFieldCtx.Templates = {};
calculatedFieldCtx.Templates.Fields = {
"Total_x0020_billing"
: {
"View"
: CalculatedFieldViewTemplate
}
};
calculatedFieldCtx.OnPostRender = [];
calculatedFieldCtx.OnPostRender.push(
()
{
// Specify id of the list view table for which you want to display sum values.
HTMLTableElement = document.getElementById(
"{ED71D9A3-58E5-44A8-B3F7-EC3AD763A558}-{F04B2518-5A35-4EEF-A0AE-1B9B64EA0947}"
);
tbodyElement = document.createElement(
'thead'
tbodyElement.id =
"customAggWPQ"
;
trElement = document.createElement(
'tr'
tdElement;
for
i = 1; i <= _totalColumn; i++) {
tdElement = document.createElement(
'th'
tdElement.id =
"tdElement"
+ i;
if
( i == _columnIndex) {
tdElement.innerHTML =
"<b>Sum= "
+ numberFormat(_totalValue) +
"</b>"
trElement.appendChild(tdElement);
tbodyElement.appendChild(trElement);
(document.getElementById(
) ==
null
) {
HTMLTableElement.insertBefore(tbodyElement,HTMLTableElement.firstChild.nextSibling);
else
document.getElementById(
+ _columnIndex).innerHTML =
})
SPClientTemplates.TemplateManager.RegisterTemplateOverrides(
calculatedFieldCtx
})();
CalculatedFieldViewTemplate(ctx) {
_totalValue += parseFloat((ctx.CurrentItem.Total_x0020_billing).replace(
','
,
''
));
return
ctx.CurrentItem.Total_x0020_billing;
numberFormat =
(number) {
sDelimeter =
number = Math.round(parseFloat(number) * 100) / 100;
numStr = (
'_'
+ number).replace(
buffer = [];
i = 0, len = numStr.length; i < len; i += 1) {
buffer.push(numStr.substring(len - 1 - i, len - i));
(((i + 1) % 3 == 0) && (i != len - 1)) {
buffer.push(sDelimeter);
buffer.reverse().join(
).replace(
",."
"."