Hi thanks for the help everyone. This is how I managed to code
function GetGridValues()
{
var rowData;
var entity;
var attribute;
var sum=0;
var i=0;
var qty;
var manual;
Xrm.Page.getAttribute("estimatedvalue").setValue(0);
manual = Xrm.Page.getAttribute("new_manuallyenterestrevenue").getValue();
if(manual==0)
{
var filteredRecordCount = Xrm.Page.getControl("FeeEstimator").getGrid().getTotalRecordCount();
for( i=0; i<filteredRecordCount ; i++)
{
rowData = Xrm.Page.getControl("FeeEstimator").getGrid().getRows().get(i).getData();
entity = rowData.getEntity();
attribute = entity.getAttributes();
qty= attribute.get("new_totalsalesprice").getValue();
sum=qty+sum;
}
Xrm.Page.getAttribute("estimatedvalue").setValue(sum);
}
}
--------------------------------------------------------------------------------------------------------
NEW JAVASCRIPT CODE
--------------------------------------------------------------------------------------------------------
function GetGridValues(executionContext)
{
var rowData;
var feeentity;
var attribute;
var sum=0;
var i=0;
var qty=0;
var formContext = executionContext.getFormContext();
var manual = formContext.getAttribute("new_manuallyenterestrevenue").getValue();
var gridContext = formContext.getControl("FeeEstimator");
var filteredRecordCount =gridContext.getGrid().getTotalRecordCount();
if(!manual)
{
for( i=0; i<filteredRecordCount ; i++)
{
rowData = gridContext.getGrid().getRows().get(i).data;
feeentity = rowData.entity;
qty = feeentity.attributes.get("new_totalsalesprice").getValue();
sum=qty+sum;
}
}
formContext.getAttribute("estimatedvalue").setValue(sum);
}