I am writing the following Javascript (JSLINK) to show the
Sum of a numeric value, as
follow:-
var
_totalValue1 = 0.0;
var _totalColumn = 27; // Specify total number of columns
in list view.
var _columnIndex1 = 14; // Specify the index of the column where
you want to display sum values. (i.e. index for first column =
1)
alert(101010);
function myCSRRendering1 ()
{
var calculatedFieldCtx = {};
calculatedFieldCtx.Templates = {};
calculatedFieldCtx.Templates.Fields = {
"Yearof2017MLC": {
"View":
CalculatedFieldViewTemplate1
}
};
SPClientTemplates.TemplateManager.RegisterTemplateOverrides(calculatedFieldCtx);
calculatedFieldCtx.OnPostRender = [];
calculatedFieldCtx.OnPostRender.push(function()
{
// Specify id
of the list view table for which you want to display sum values.
var HTMLTableElement =
document.getElementById("{B3D883A5-6962-47FD-BDEF-BB83FF4C78EA}-{C86BA145-8C22-47E8-938C-11B8C7F855C3}");
var tbodyElement = document.createElement('thead');
tbodyElement.id =
"customAggWPQ";
var trElement =
document.createElement('tr');
var tdElement;
for(var i
= 1; i <= _totalColumn; i++) {
tdElement =
document.createElement('th');
tdElement.id = "tdElement" +
i;
if( i == _columnIndex1) {
tdElement.innerHTML = "Sum=
" + numberFormat(_totalValue1) + "";
}
trElement.appendChild(tdElement);
}
tbodyElement.appendChild(trElement);
if(document.getElementById("customAggWPQ") == null) {
HTMLTableElement.insertBefore(tbodyElement,HTMLTableElement.firstChild.nextSibling);
}
else {
document.getElementById("tdElement" +
_columnIndex1).innerHTML = "Sum= " + numberFormat(_totalValue1) +
"";
}
_totalValue1 = 0.0;
})
SPClientTemplates.TemplateManager.RegisterTemplateOverrides(
calculatedFieldCtx
);
};
function
CalculatedFieldViewTemplate1(ctx) {
if(ctx.CurrentItem.Yearof2017MLC != "" ){
_totalValue1
+= parseFloat((ctx.CurrentItem.Yearof2017MLC).replace(',', ''));
return
ctx.CurrentItem.Yearof2017MLC;
}
else
{
return
0;
}
}
// register for MDS enabled
sites
RegisterModuleInit('http://arqcvsps01/offices/resources/t10.js',
myCSRRendering1);
// fallback for non-MDS enabled
sites
myCSRRendering1();
var numberFormat = function(number)
{
return
number;
};
now
the result i should get is 97.4456
while the JSLINK is showing
97.44560000000001
.. here is my
table:-
href="https://i.stack.imgur.com/IaiSm.png" rel="nofollow noreferrer"> src="https://i.stack.imgur.com/IaiSm.png" alt="enter image description
here">
so can anyone advice on this
please?
No comments:
Post a Comment