Data Table not updating decimal values in Total column

Forms
1

Hi Team,

image
image841×201 5.68 KB

I am trying to add column values to the Total column in DataTable, but the total is not getting decimal value. It should be same as below Total amount.

Below is the code.

fd.control("DataTable1").columns[6].editable = function () {
return false;
};

fd.control("DataTable1").$on('change', function(value) {
var hoursTotal = 0.0;

if (value) {
    // go through each row one by one
    for (var i = 0; i < value.length; i++) {
    var dayHours=parseFloat(value[i].Mon +value[i].Tues +value[i].Wed + value[i].Thurs + value[i].Fri);
     // calculate total for the row
        value[i].set('Total',dayHours);
        if (value[i].Total) {
            hoursTotal += parseFloat(value[i].Total);
        }
    }
}
   fd.field('NoHrs').value = hoursTotal;

});

Thank you in advance.

2

Dear @navpreet,
Make sure all fields have the same number of decimals, otherwise it's hard to say where exactly the issue begins and stops.

3

@Nikita_Kurguzov Thank you it worked, yes number of decimals is not same for one of the columns in properties.