求助:下面统计代码统计出来的占比怎么是0.333,而不是%,应该怎么改代码?
Dim g As New SQLCrossTableBuilder("统计表2","订单主表")g.Cg.HGroups.AddDef("预付定金日期", DateGroupEnum.Year, "年")g.HGroups.AddDef("预付定金日期", "月")g.VGroups.AddDef("初审是否通过", "通过初审|未通过初审")g.Totals.AddDef("预付定金", "定金")g.VerticalTotal = Trueg.VerticalProportion = Trueg.Decimals = 2g.FromServer = True
Tables("销售统计_Table1").DataSource = g.BuildDataSource
生成以后,直接修改,如代码
DataTables("表A").DataCols("第一列").SetFormat("0.00%")
http://www.foxtable.com/webhelp/scr/0193.htm