Devexpress 分组自定义分组合计栏公式

系统：windows 7

软件：VS2015  

语言：C#  WINFORM

设计：DEVEXPRESS  GRIDCONTROL

结论：根据设计软件自定义分组  自定义分组合计栏计算公式   非传统的SUM等

事件：bandedGridView1_CustomDrawRowFooterCell

方法：

private void bandedGridView1_CustomDrawRowFooterCell ( object sender ,FooterCellCustomDrawEventArgs e )
        {
            //this.AN017:GridView中的列  AN006、 U1均是
            if ( e.Column == this.AN017 )
            {
                decimal d1 = this.bandedGridView1.GetRowFooterCellText( e.RowHandle ,this.AN006 ) == "" ? 0 : 
                              Convert.ToDecimal( this.bandedGridView1.GetRowFooterCellText( e.RowHandle ,this.AN006 ) );
                decimal d2 = this.bandedGridView1.GetRowFooterCellText( e.RowHandle ,this.U1 ) == "" ? 0 : 
                              Convert.ToDecimal( this.bandedGridView1.GetRowFooterCellText( e.RowHandle ,this.U1 ) );
                decimal d3 = d1 == 0 ? 0 : Math.Round( d2 / d1 ,2 );
                e.Info.DisplayText = d3.ToString( );
            }
        }

效果：

转载地址：http://blog.youkuaiyun.com/kamboo/article/details/6790846