CodeDemo

柜台库存报表: 库存周转率:如果是门店的话,销售减去退货的销售件数/平均库存量;否则,(出库件数+批发出货件数-批发退货件数)/平均库存量 库存周转天数:如果是门店的话,查询时间天数*(平均库存量/销售减去退货的销售件数);否则,查询时间天数*(平均库存量/出库件数+批发出货件数-批发退货件数) 如果是门店的话 AvgInventoryAmount:平均库存量 TotalSaleAmount:减去退货的销售件数 InventoryOut:出库件数 BatchSaleAmount:批发出货件数 BatchReturnAmount:批发退货件数 StrDays:查询时间天数 =Format( Math.Abs( IIF( val(Fields!StoreCategory.Value)=20, IIf( val(Fields!AvgInventoryAmount.Value)=0,0,val(Fields!TotalSaleAmount.Value)/val(Fields!AvgInventoryAmount.Value)), IIf( val(Fields!AvgInventoryAmount.Value)=0,0,val(Fields!InventoryOut.Value+Fields!BatchSaleAmount.Value+Fields!BatchReturnAmount.Value)/val(Fields!AvgInventoryAmount.Value)))),"0.00%") =Format(Math.Abs( IIF( val(Fields!StoreCategory.Value)=20, IIf( val(Fields!TotalSaleAmount.Value)=0,0,val(Fields!StrDays.Value)*val(Fields!AvgInventoryAmount.Value)/val(Fields!TotalSaleAmount.Value)), IIf( val(Fields!InventoryOut.Value+Fields!BatchSaleAmount.Value+Fields!BatchReturnAmount.Value)=0,0, val(Fields!StrDays.Value)*val(Fields!AvgInventoryAmount.Value)/val(Fields!InventoryOut.Value+Fields!BatchSaleAmount.Value+Fields!BatchReturnAmount.Value)))),"0")