易表在线答疑技术与交流用户社区 → 请帮忙简化一下公式


  共有7534人关注过本帖平板打印复制链接

主题:请帮忙简化一下公式

帅哥哟,离线,有人找我吗?
zhou5539011
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:论坛游民 帖子:85 积分:0 威望:0 精华:0 注册:2007/2/27 14:59:00
请帮忙简化一下公式  发帖心情 Post By:2007/4/17 11:32:00 [只看该作者]

if([%季度%]=1,SumFor("送货明细","数量","规格","=",[规格],"季度","=","1"),
if([%季度%]=2,SumFor("送货明细","数量","规格","=",[规格],"季度","=","1")+SumFor("送货明细","数量","规格","=",[规格],"季度","=","2"),
if([%季度%]=3,SumFor("送货明细","数量","规格","=",[规格],"季度","=","1")+SumFor("送货明细","数量","规格","=",[规格],"季度","=","2")+SumFor("送货明细","数量","规格","=",[规格],"季度","=","3"),
if([%季度%]=4,SumFor("送货明细","数量","规格","=",[规格],"季度","=","1")+SumFor("送货明细","数量","规格","=",[规格],"季度","=","2")+SumFor("送货明细","数量","规格","=",[规格],"季度","=","3")+SumFor("送货明细","数量","规格","=",[规格],"季","=","4"),true))))

 回到顶部