|
请介绍一下Like,8个比较函数的后三个,
谢谢!
-=-=-=- 以下内容由 hcy1185 在 2011年04月08日 10:17pm 时添加 -=-=-=-
我觉得"定额含量"表的"金额"列刷新公式还得改,按同一定额子目的所有行,"类别"列中没有"机械"时,设置条件,
-=-=-=- 以下内容由 hcy1185 在 2011年04月08日 10:19pm 时添加 -=-=-=-
If([定额编号] >= 1205 And [定额编号] <= 1236 Or [定额编号] >= 2109 And [定额编号] <= 2140,If([类别] = "材料费%",Sumfor("定额含量","金额","定额编号","=",[定额编号],"类别","=","材料") * (Sumfor("定额含量","含量","定额编号","=",[定额编号],"类别","=","材料费%")/100),If([类别] = "机械费%",Sumfor("定额含量","金额","定额编号","=",[定额编号],"类别","=","材料") * (Sumfor("定额含量","含量","定额编号","=",[定额编号],"类别","=","机械费%")/100),[含量] * [定额材料!单价/元])),If([类别] = "材料费%",Sumfor("定额含量","金额","定额编号","=",[定额编号],"类别","=","材料") * (Sumfor("定额含量","含量","定额编号","=",[定额编号],"类别","=","材料费%")/100),If([类别] = "机械费%",Sumfor("定额含量","金额","定额编号","=",[定额编号],"类别","=","机械") * (Sumfor("定额含量","含量","定额编号","=",[定额编号],"类别","=","机械费%")/100),[含量] * [定额材料!单价/元])))
这个公式虽然计算正确,但"定额编号"列的属性设置字符型便于使用补充定额
|
加好友 
发短信
Post By：2011/4/8 16:00:00 [显示全部帖子]
Post By：2011/4/8 17:04:00 [显示全部帖子]
Post By：2011/4/8 20:39:00 [显示全部帖子]
Post By：2011/4/8 22:12:00 [显示全部帖子]
