| 以文本方式查看主题 - 易表在线答疑 (http://egrid2000.com/dvbbs/index.asp) -- 用户社区 (http://egrid2000.com/dvbbs/list.asp?boardid=2) ---- 关于最大值用于会员类型筛选 (http://egrid2000.com/dvbbs/dispbbs.asp?boardid=2&id=2107) |
| -- 作者：ruochen -- 发布时间：2011/8/9 17:45:00 -- 关于最大值用于会员类型筛选 版主好：我想在“会员类型”列，根据顾客充值的最大值确定其类型，有“会员卡”，“ 金卡”，“ 贵宾卡”，“非会员”类别。怎么下面的公式不正确呢？请帮忙检查，感谢！ if(if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 100,"会员卡",if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 200,"金卡",if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 500,"贵宾卡", "非会员" )))) egd文件下载 |
| -- 作者：Czy -- 发布时间：2011/8/10 0:33:00 -- if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 500,"贵宾卡", if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 200,"金卡", if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 100,"会员卡", "非会员" ))) |
| -- 作者：ruochen -- 发布时间：2011/8/10 8:26:00 -- 总谢谢总版主，懂了，我把逻辑关系弄反了，非常感谢！ |
| -- 作者：lyang70 -- 发布时间：2011/8/10 10:51:00 -- [这个贴子最后由lyang70在 2011/08/10 10:53am 第 1 次编辑] 重复贴... |