用友商貿(mào)通 頁小計大寫套打
來源:原創(chuàng) 發(fā)布時間:2017-03-21 15:31:59
套打函數(shù)。。
----
[IF((Length([主項數(shù)據(jù)."成交金額"] * 100)-7)>0,Copy(CurrToBigNum(Copy([主項數(shù)據(jù)."成交金額"]*100,Length([主項數(shù)據(jù)."成交金額"]*100)-7,1)),1,2),\' \')]十[IF((Length([主項數(shù)據(jù)."成交金額"] * 100)-6)>0,Copy(CurrToBigNum(Copy([主項數(shù)據(jù)."成交金額"]*100,Length([主項數(shù)據(jù)."成交金額"]*100)-6,1)),1,2),\' \')]萬[IF((Length([主項數(shù)據(jù)."成交金額"] * 100)-5)>0,Copy(CurrToBigNum(Copy([主項數(shù)據(jù)."成交金額"]*100,Length([主項數(shù)據(jù)."成交金額"]*100)-5,1)),1,2),\' \')]千[IF((Length([主項數(shù)據(jù)."成交金額"] * 100)-4)>0,Copy(CurrToBigNum(Copy([主項數(shù)據(jù)."成交金額"]*100,Length([主項數(shù)據(jù)."成交金額"]*100)-4,1)),1,2),\' \')]百[IF((Length([主項數(shù)據(jù)."成交金額"] * 100)-3)>0,Copy(CurrToBigNum(Copy([主項數(shù)據(jù)."成交金額"]*100,Length([主項數(shù)據(jù)."成交金額"]*100)-3,1)),1,2),\' \')]十[IF((Length([主項數(shù)據(jù)."成交金額"] * 100)-2)>0,Copy(CurrToBigNum(Copy([主項數(shù)據(jù)."成交金額"]*100,Length([主項數(shù)據(jù)."成交金額"]*100)-2,1)),1,2),\' \')]元[IF((Length([主項數(shù)據(jù)."成交金額"] * 100)-1)>0,Copy(CurrToBigNum(Copy([主項數(shù)據(jù)."成交金額"]*100,Length([主項數(shù)據(jù)."成交金額"]*100)-1,1)),1,2),\' \')]角[IF((Length([主項數(shù)據(jù)."成交金額"] * 100)-0)>0,Copy(CurrToBigNum(Copy([主項數(shù)據(jù)."成交金額"]*100,Length([主項數(shù)據(jù)."成交金額"]*100)-0,1)),1,2),\' \')]分
----