ejGrid Summary

Question

I have an ejGrid with a summary.It does not seem to allow me to format a column that brings in doubles to "{0:0:00}"what should I do to establish total sums to the hundredth place on summary rows and total summary row?

Sathyanarayanamoorthy Eswararao · Answer

Hi Nicholas, 

Thanks for contacting Syncfusion support. 

Query 1: It does not seem to allow me to format a column that brings in doubles to "{0:0:00}" 
 
We have analyzed the query and found that you want to set the format for the column based on two decimal point. We have inbuilt support to set the format using the format property of the column in grid. 
 
Refer the blow code example. 
 





 
$("#Grid").ejGrid({ 
    /// the datasource "window.gridData" is referred from jsondata.min.js 
    dataSource: data, 
                allowPaging: true, 
              showSummary: true, 
                pageSettings: { pageSize: 10 }, 
                summaryRows: [ 
                    { title: "Sum", summaryColumns: [{ summaryType: ej.Grid.SummaryType.Sum, displayColumn: "Freight", dataMember: "Freight", format: "{0:N2}" }] }, 
                             ], 
                columns: [ 
                         { field: "ID", headerText: "ID", width: 90 }, 
                  { field: "Freight", headerText: "Freight", width: 110,format: "{0:N2}" }, 
                         ] 
            }); 
        }); 
 
    
We have prepared a Js Playground sample for your reference and the same can be found below. 

Sample: http://jsplayground.syncfusion.com/hh2ycl0p 

Refer the following documentation for format details. 

Link: https://help.syncfusion.com/js/grid/summary#format 

Link: https://help.syncfusion.com/js/grid/columns#format 



Query 2: what should I do to establish total sums to the hundredth place on summary rows and total summary row? 
 
We have checked the query and we are quite unclear regarding this requirement. So please provide the following details. 
 

Share the Pictorial representation of your requirement.
Share the Syncfusion Essential studio version.
Code example of the grid.
Share the exact scenario of your requirement.  
 
The provided details will help us to analyze the issue and provide the solution as soon as possible. 
 
Regards, 
Sathyanarayanamoorthy

Becky · Answer

Thank you. It worked. I missed that

Sathyanarayanamoorthy Eswararao · Answer

Hi Nicholas, 

We are happy to hear that your issue has been solved. 
If you need any further assistance please get back to us. 

Regards, 
Sathyanarayanamoorthy