jQuery Grid Plugin - jqGrid - Topic: Multi-level grouping summary mis-calculations or misplacement

tony on Multi-level grouping summary mis-calculations or misplacement

Sat, 13 Sep 2014 12:58:07 +0300

Hello,

There was more fixes on this. Please, if possible download all the code and use grid base, common and grouping modules (other modules can be requiered maybe)

If it is difficult for you I will send you the fixed version

Thanks

ricardo on Multi-level grouping summary mis-calculations or misplacement

Sun, 31 Aug 2014 02:30:51 +0300

tony said
Hello,

Â

I have fixed the problem in GitHub here.

Please let me know if you have difficulties to run and test the fix

Â

Kind Regards

Tony-

Â Â Â Â Thanks For the Help.Â

Â Â Â Â I applied the suggested solution but It has NOT solved the problem. Â¿Could you please check again?

tony on Multi-level grouping summary mis-calculations or misplacement

Thu, 24 Jul 2014 12:54:36 +0300

Hello,

I have fixed the problem in GitHub here.

Please let me know if you have difficulties to run and test the fix

Kind Regards

tony on Multi-level grouping summary mis-calculations or misplacement

Wed, 16 Jul 2014 13:58:48 +0300

Hello,

Thank you for the test case.
I reproduce the problem. Will try to fix ASAP.

Kind Regards
Tony

ricardo on Multi-level grouping summary mis-calculations or misplacement

Mon, 14 Jul 2014 19:11:43 +0300

Tony-

Here is the requestedData:

var ReportLinesÂ = [
 {Lob:"VOIP REVENUE",Type:"COMMERCIAL INCOME",AccountNumber:"97000-691-90-2",ServiceCode:"3300::H9",NetRevenue01:"1500000.00"},
 {Lob:"VOIP REVENUE",Type:"COMMERCIAL INCOME",AccountNumber:"97000-691-90-3",ServiceCode:"3300::K9",NetRevenue01:"3000000.00"},
 {Lob:"VOIP REVENUE",Type:"TELEPHONY INCOME",AccountNumber:"97000-691-90-4",ServiceCode:"3300::09",NetRevenue01:"1600000.00"},
 {Lob:"VOIP REVENUE",Type:"TELEPHONY INCOME",AccountNumber:"97000-691-90-5",ServiceCode:"3300::J9",NetRevenue01:"2900000.00"},
 {Lob:"DRONE REVENUE",Type:"TICKLE INCOME",AccountNumber:"97000-691-90-6",ServiceCode:"3300::P9",NetRevenue01:"1600000.00"},
 {Lob:"DRONE REVENUE",Type:"TICKLE INCOME",AccountNumber:"97000-691-90-7",ServiceCode:"3300::C9",NetRevenue01:"2900000.00"},
 ];

Please replaceÂ result.Reportlines with ReportLinesÂ in the data portion of the jqgrid.

tony on Multi-level grouping summary mis-calculations or misplacement

Mon, 14 Jul 2014 17:57:29 +0300

Hello,
In order to do the full description can you please post the data which causes the problem?
Thank you

Regards

ricardo on Multi-level grouping summary mis-calculations or misplacement

Sun, 13 Jul 2014 08:41:29 +0300

I have a jqgrid configurationÂ with three-level grouping and summary totals for revenue column.Â

It does wellÂ in terms of the desired grouping.

However, when it comes to summaries, only the two outermost level groupings are showing the correct sum total. The innermost group-levels are showing exactlyÂ the same summary value as the parent group-level when it shouldn't.Â

For example,

Group A has a revenue total of $8,000,000;

Group A1 has $4,500,000;

Both Group A1.i and Group A1.ii both shows $4,500,000 (same as the parent level group) , when it should be $1,500,000 and $3,000,000 respectively adding up to the parents total. Â Â Â Â

-Same pattern for all third-level groupings.-

I will appreciate all the help on this.

Â Here is the code:

jQuery("#48remote4").jqGrid(
{
data: result.ReportLines,
datatype: "local",
colNames:['LoB ', 'type' , 'Account Number', 'Service Code','Total'],
colModel:[
{
name:'LoB',index:'LoB', editable:true, align:"center",sorttype:'text', hidden:false
},
{
name:'Type',index:'Type', editable:true, align:"center",sorttype:'text', hidden:false, width:30
},
{
name:'AccountNumber',index:'AccountNumber', editable:true, align:"center",sorttype:'text'
},
{
name:'ServiceCode',index:'ServiceCode', align:"center", sortable:true, width:90
},
{
name:'NetRevenue01',index:'NetRevenue01',align:"right",summaryType:'sum', summaryTpl : '<b>{0}</b>',formatter:'currency', width:70
}
],
rowNum:1000,
rowList:[100, 200, 500, 1000],
height: 'auto',
width: 'auto',
pager: '#p48remote4',
sortname: 'AccountNumber',
viewrecords: false,
sortorder: "asc",
caption:"Annual Revenue Report",
grouping: true,
groupingView:
{
groupField : ['LoB', 'Type', 'AccountNumber'],
groupColumnShow : [true, false, true],
hideFirstGroupCol:true,
groupText : ['<b>{0}</b>'],
groupCollapse : true,
groupOrder: ['asc','asc','asc'],
groupDataSorted : true,
groupSummaryPos: ['header', 'header', 'header'],
showSummaryOnHide: [true, true, true]
},
footerrow: true,
userDataOnFooter: trueÂ

}