jQuery Grid Plugin - jqGrid - Topic: Jqgrid Group Header Text displaying Sum

rize on Jqgrid Group Header Text displaying Sum

Wed, 23 Jul 2014 17:18:38 +0300

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

Works perfectly.

Thanks again.

Ryan

tony on Jqgrid Group Header Text displaying Sum

Wed, 23 Jul 2014 13:25:07 +0300

Hello,

To fix the problem you will need to use summaryRound and/or summaryRoundType in the colModel definition.
See here.

Regards

rize on Jqgrid Group Header Text displaying Sum

Wed, 23 Jul 2014 10:32:47 +0300

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: [' {0}Â Â 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: [' {0}Â Â Total Amount: "+ formatAmount('{Amount}')], " Â just passes Â in the string

Does anyone know theÂ fixÂ or work around.

I am desperate.

Thanks

Ryan

Rekha on Jqgrid Group Header Text displaying Sum

Wed, 04 Sep 2013 00:51:37 +0300

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: [' {0} Total Amount: {Amount}’],

groupColumnShow: [true],

groupSummary: [true],

groupCollapse: true,

groupOrder: ['asc'],

showSummaryOnHide: false,

Please help.

Thank s & Regards

Rekha