以文本方式查看主题 - 易表在线答疑 (http://egrid2000.com/dvbbs/index.asp) -- 用户社区 (http://egrid2000.com/dvbbs/list.asp?boardid=2) ---- 汇总模式出现问题 (http://egrid2000.com/dvbbs/dispbbs.asp?boardid=2&id=29209) |
-- 作者:zmdb -- 发布时间:2017/3/30 9:32:00 -- 汇总模式出现问题 以前都好好的,我什么公式都没动,可昨天起突然莫名奇妙无法生成汇总模式: 以下公式无法生成汇总模式:ShowAllRows() Filterfor("挂账日期","=",today()) and Filterfor("区域","<>","tm") and Filterfor("区域","<>","t") and Filterfor("区域","<>","b") and Filterfor("区域","<>","yd") and Filterfor("区域","<>","g") and Filterfor("区域","<>","s") and Filterfor("区域","<>","大区") and Filterfor("区域","<>","地办") and Filterfor("区域","<>","民康") and Filterfor("区域","<>","县办") and Filterfor("执行情况","<>","供不应求") and Filterfor("执行情况","<>","供不应求(压货)") and Filterfor("执行情况","<>","资信未审过") and Filterfor("执行情况","<>","合同不合格") and Filterfor("执行情况","<>","特批待审")and movecol("规格",1) and movecol("产品名称",3) and movecol("件数",2) and subtotal("规格","发货数量,件数,金额","2,2,2") and do(277) 而下面这个公式可以:ShowAllRows() and Filterfor("挂账日期","=",today()) and Filterfor("区域","<>","y") and Filterfor("区域","<>","b") and Filterfor("区域","<>","g") and Filterfor("区域","<>","s") and Filterfor("区域","<>","tm") and Filterfor("区域","<>","t") and Filterfor("区域","<>","连锁") and Filterfor("执行情况","<>","供不应求") and Filterfor("执行情况","<>","资信未审过") and Filterfor("执行情况","<>","合同不合格") and Filterfor("执行情况","<>","特批待审") and movecol("规格",1) and movecol("产品名称",3) and movecol("件数",2) and subtotal("规格","件数","2") and do(277) 请高手帮我看看到底是哪里出现了问题(我要生成汇总模式啊)。
|
-- 作者:wjq1072 -- 发布时间:2017/3/30 9:54:00 -- 没有发现问题。发文件上来看看? |