工效 = 工时 / YS1，应该 25 / 27 = 0.9259，但是结果却是1.8333，是哪里出问题，请各位老师指教，谢谢！
Dim rq As String = Format( Functions.Execute("fwqsj","ABC"),"yyyy-MM-dd")
Dim sql,s As String
sql = "SELECT 日期,单位,员工,SUM(工时) AS 工时,SUM(YS1) AS YS1,Count(*) AS 计数,SUM(工时) / SUM(YS1) As 工效 FROM {C} GROUP BY 日期,单位,员工,工时,YS1"
Dim b As New CrossTableBuilder("统计",sql,"ABC")
b.HGroups.AddDef("单位")
b.HGroups.AddDef("员工")
b.VGroups.AddDef("日期",DateGroupEnum.None)
b.Totals.AddDef("计数")
b.Totals.AddDef("工时")
b.Totals.AddDef("YS1")
b.Totals.AddDef("工效")
b.VerticalTotal = True
b.Build()
MainTable = Tables("统计") '打开生成的统计表
Tables("统计").AutoSizeCols()
此主题相关图片如下：捕获.jpg
[此贴子已经被作者于2014-9-28 15:49:31编辑过]
加好友 
发短信
Post By：2014/9/28 10:55:00 [只看该作者]
