Calculate sum of a column of a subgrid in an entity using custom script

(0) Share

Report

Posted on by Community Member

My Dynamics 365 CRM is in Version 9 and there is not enough reference on this issue I am facing. I am looking for a custom script to get a sum of a column of a subgrid in an entity. I have an entity with a field name "total_amount", on that entity , i have a form with a subgrid referenced to another entity, which possess the records where i have product lines in it. How do i sum up the price of the product line, and insert the sum into "total_amount" field?

Currently i'm trying to use the gridcontext to achieve this but there isnt proper reference as to how do i use it to extract the column value and total it up.

I found this code but its only for older version of CRM :

setTimeout(calcCostoTotal, 3000);
}
function calcCostoTotal() {
var grid = document.getElementById(‘Deals’);
var ids = grid.control.get_allRecordIds();
var sum = 0.00;
var cellValue;
for(i = 0; i < ids.length; i++) {
var cellValue = grid.control.getCellValue(‘NAME OF THE FILED THAT IS BEING SUMMED’,ids[i]);
var number = Number(cellValue.replace(/[^0-9\.]+/g,”));
sum = sum + number;
}
Xrm.Page.data.entity.attributes.get(“NAME OF THE FILED THAT THE SUM IS GOING TO”).setValue(sum);
}

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sean,

The simple way is that you can handle through Plugin whenever new record created/updated to calculate the sum.

still you want to go with the Javascript , you can move the code to subgrid onlaod Event and calculate the SUM.

docs.microsoft.com/.../subgrid-onload

https://youtu.be/0h15viM19Ic

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Write web API query passing the parent Guid of the record to subgrid entity and prepare the sum of the columns.

Have a look below reference similar requirement -

community.dynamics.com/.../296630

Use CRMRestBuilder to get the query -

www.youtube.com/watch

Was this reply helpful? Yes No
Suggested answer

naresh babu 425 on at

Like (0)

Report
Copy link

Link copied!

Try this below script:-
Xrm.Page.getControl('salesorderdetailsGrid').getGrid().getRows().get(i).getData().getEntity().getAttributes().get('priceperunit').getValue();
________________________________________________

function CostoTotal()
{
debugger;
if (Xrm.Page != null && Xrm.Page != undefined && Xrm.Page.getControl("salesorderdetailsGrid") != null && Xrm.Page.getControl("salesorderdetailsGrid") != undefined) {
var count = Xrm.Page.getControl("salesorderdetailsGrid").getGrid().getTotalRecordCount();
alert("Total Products:"+count);
for(i = 0; i < count; i++) {
var gridControl = Xrm.Page.getControl('salesorderdetailsGrid').getGrid().getRows().get(i).getData().getEntity().getAttributes().get('priceperunit').getValue();
//Xrm.Page.getControl('salesorderdetailsGrid').getGrid().getRows().get(0).getData().getEntity().getAttributes().get('priceperunit').getValue();
alert(gridControl );
// var sum = 0,00;
var cellValue = gridControl;
alert(cellValue);
cellValue = cellValue.replace( /,/,"." );
alert(cellValue);
var sum = sum + parseFloat(cellValue);
alert(sum);
}
}
Xrm.Page.getAttribute('new_total').setValue(sum);
}

Was this reply helpful? Yes No
Jian Qi 10 on at

Like (0)

Report
Copy link

Link copied!

I believe this is for the older version of crm.

Was this reply helpful? Yes No