jQuery Grid Plugin - jqGrid

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.....qgrid.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: ['Order'],

                    groupDataSorted: true,

                    groupText: ['<b> {0}  </b>  Total Amount: {Amount}’],

                    groupColumnShow: [true],

                    groupSummary: [true],

                    groupCollapse: true,

                    groupOrder: ['asc'],

                    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: ['<b> {0}  </b>  Total Amount: "+ formatAmount('{Amount}')], "   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