@Rekha said:
Hi,

This is regarding Jqgrid Group Header Text displaying Sum in the group Text.

I want the sum of a particular group displayed in the group header. I found this approach on the http://trirand.com/blog/jqgrid/jqgrid.html  demo site and it works. This issue is that, when I am trying to sum a currency, the group text  displays “3117.1499999999996”  The extra trailing decimals show up. But when I display on the group Summary, it displays fine as “3117.15”.

colModel: [ ……….

{ name: ‘Amount’, sortable: true, formatter: ‘currency’, align: “right”, sorttype: ‘currency’, decimalPlaces: ‘2’, summaryType: ‘sum’, defaultValue: ‘0.00’ }]

groupingView: {

                    groupField: ,

                    groupDataSorted: true,

                    groupText: ,

                    groupColumnShow: [true],

                    groupSummary: [true],

                    groupCollapse: true,

                    groupOrder: ,

                    showSummaryOnHide: false,

                },

Please help.

Thank s & Regards

Rekha

 

Hi,

I also have this exact problem , it does the same with number formatting as well not just currency. 

I have tried using a function to return the trimmed value but I don’t know how to pass the value {0} or {Amount}  into the function.

“ groupText: , ”   just passes  in the string

Does anyone know the fix or work around.

I am desperate.

 

Thanks

Ryan

You are a life saver … this was driving me insane.

Works perfectly.

 

Thanks again.

Ryan