Convert((IIF([方向] ='买入',[买卖价格] * [数量] * 100.001/100+[买卖价格] * [数量] *0.00687/100 + [买卖价格] * [数量] * 0.0002+IIF(([买卖价格] * [数量] *0.00687/100 + [买卖价格] * [数量] * 0.0002)<5,5-([买卖价格] * [数量] *0.00687/100 + [买卖价格] * [数量] * 0.0002),0),([买卖价格] * [数量] *(-1)*0.001/100+[买卖价格] * [数量] *(-1)*0.00687/100 + [买卖价格] * [数量] *(-1)* 0.0002+IIF(([买卖价格] * [数量] *(-1)*0.00687/100 + [买卖价格] * [数量] *(-1)* 0.0002)<5,5-([买卖价格] * [数量]*(-1) *0.00687/100 + [买卖价格] * [数量] *(-1)*0.0002),0)+[买卖价格] * [数量] *(-1)*0.001)+[买卖价格] * [数量])*100),'System.Int64') / 100
|