item本期采购入库金额为负
从表的公式来看，如“本期收进/采购入库”，本期“采购入库”的数量和金额公式如下： 1）金额 if mid({?fromdate},1,4)=mid({?todate},1,4) then //从fromdate字段中把第1位到第4位取出，判断数值在范围内否，在这里是“如果输入的开始年度和结束年度是一样的”，那么„„ if {ICHIST.FISCYEAR} = mid({?fromdate},1,4) //IC Tansaction History的Fisc Year如果等于输入的年度 AND {ICHIST.FISCPERIOD} >=ToNumber (mid({?fromdate},5,2)) AND {ICHIST.FISCPERIOD} <= ToNumber( mid({?todate},5,2) ) and (({ICHIST.TRANSTYPE}=1 OR {ICHIST.TRANSTYPE}=2 OR {ICHIST.TRANSTYPE}=3 ) ) //IC Tansaction History的交易类型为Receipt、Receipt Ajustment、Receipt Return。 then {ICHIST.HOMEEXTCST} else 0 //Extended Cost - Functional，用本位币显示扩展成本 else (if ({ICHIST.FISCYEAR} = mid({?fromdate},1,4) AND {ICHIST.FISCPERIOD} >=ToNumber (mid({?fromdate},5,2)) ) OR //输入的开始年度对应并且大于等于输入的期间，或者„„ ( {ICHIST.FISCYEAR} = mid({?todate},1,4) AND {ICHIST.FISCPERIOD} <= ToNumber(mid({?todate},5,2) )) OR //输入的结束年度并且小于等于输入的期间页:
[1]