get column total using javascript

Question

get column total using javascript

RAVI 1,076

Hello

Im using this javascript to filter my repater control

<script type="text/javascript">  
       
     $(document).ready(function() {  
    $('#list').DataTable( {  
        initComplete: function () {  
            this.api().columns("1").every( function () {  
                var column = this;  
                var select = $('<select><option value=""></option></select>')  
                    .appendTo( $("#Span1").empty() )  
                    .on( 'change', function () {  
                        var val = $.fn.dataTable.util.escapeRegex(  
                            $(this).val()  
                        );  
   
                        column  
                            .search( val ? '^'+val+'$' : '', true, true )  
                            .draw();  
                    } );  
   
                column.data().unique().sort().each( function ( d, j ) {  
                    select.append( '<option value="'+d+'">'+d+'</option>' )  
                } );  
            } );

how to get column total when i do filters

need help
thanks

QiYou-MSFT 4,326 Microsoft External Staff

Hello @RAVI
Do you want to know the overall number of columns? You can refer to the following code:

 function calcTotal(txtBox, totBox)   
    {   
        var totVal;   
        try   
        {    
        totVal = document.getElementById(totBox).value;   
        if(totVal!= null && totVal!='')   
         {   
           document.getElementById(totBox).value= eval(parseInt(document.getElementById(totBox).value) + parseInt(txtBox.value));      
         }   
         else   
         {   
            document.getElementById(totBox).value= txtBox.value;              
         }   
        }   
        catch(e)   
        {}   
    }

The item you can follow what you used.

Best regards,
Qi You

QiYou-MSFT 4,326 Reputation points Microsoft External Staff

2022-10-31T09:03:02.387+00:00

Hello @RAVI ，
Can you give me more details and needs? For example, the styles you need to do and the controls you need to filter the data and whether all columns or individual columns are the sum of some. When I have these, I will better help you solve the problem.

Best regards,
Qi You

Your answer

QiYou-MSFT 4,326 Reputation points Microsoft External Staff

2022-10-28T09:45:11.517+00:00

Hello @RAVI
Do you want to know the overall number of columns? You can refer to the following code:

function calcTotal(txtBox, totBox) { var totVal; try { totVal = document.getElementById(totBox).value; if(totVal!= null && totVal!='') { document.getElementById(totBox).value= eval(parseInt(document.getElementById(totBox).value) + parseInt(txtBox.value)); } else { document.getElementById(totBox).value= txtBox.value; } } catch(e) {} }

The item you can follow what you used.

Best regards,
Qi You
QiYou-MSFT 4,326 Reputation points Microsoft External Staff

2022-10-31T09:03:02.387+00:00

Hello @RAVI ，
Can you give me more details and needs? For example, the styles you need to do and the controls you need to filter the data and whether all columns or individual columns are the sum of some. When I have these, I will better help you solve the problem.

Best regards,
Qi You

Share via

get column total using javascript

Your answer