Dim g As New GroupTableBuilder("需求辅助", DataTables("需求统计"))
g.Groups.AddDef("子项物料代码")
g.Groups.AddDef("物料名称")
g.Groups.AddDef("规格型号")
g.Totals.AddDef("总欠料", AggregateEnum.Average)
g.Filter = "[总欠料] < 0 and [总需求] > 0"
g.Build()
MainTable = Tables("需求辅助")
DataTables("需求辅助").DataCols.Add("总欠料2",Gettype(Double),"总欠料*-1")