【正文】 ............................................................................................................. 68 第三 節(jié) 創(chuàng)建和修改公式 ............................................................................................................................. 69 1 創(chuàng)建公式并將其插入到報表中 ...................................................................................................... 69 2 編輯公式 .............................................................................................................................................. 69 3 將公式從一個報表復(fù)制到另一個報表 ......................................................................................... 69 第四節(jié) 刪除公式 ........................................................................................................................................... 70 IFS 系統(tǒng)集成水晶報表開發(fā)實(shí)用手冊 北京用友艾福斯軟件系統(tǒng)有限公司 2 電話： 02163543977 01082513666 1 從報表刪除工作公式 ........................................................................................................................ 70 2 刪除公式規(guī)范 ..................................................................................................................................... 70 第五節(jié) 錯誤消息和公式編譯器警告 ....................................................................................................... 71 第六節(jié) 水晶報表中的函數(shù) ......................................................................................................................... 80 1 數(shù)學(xué) ....................................................................................................................................................... 80 Abs (x) ......................................................................................................................................................... 81 Sgn (number) .............................................................................................................................................. 81 Int (number) ............................................................................................................................................... 82 Round (x), Round (x, places)................................................................................................................... 83 Truncate (x)、 Truncate (x, places) ......................................................................................................... 84 Fix ................................................................................................................................................................ 85 Remainder (num, denom).......................................................................................................................... 86 Sin (number) ............................................................................................................................................... 87 Cos (number) .............................................................................................................................................. 87 Tan (number) .............................................................................................................................................. 88 Atn (number) .............................................................................................................................................. 88 Pi .................................................................................................................................................................. 89 Sqr (number) .............................................................................................................................................. 89 Exp (number).............................................................................................................................................. 89 Log (number).............................................................................................................................................. 90 Rnd .............................................................................................................................................................. 90 2 摘要（匯總） ..................................................................................................................................... 91 Sum （求和） ............................................................................................................................................ 91 Average（求平均值） ................................................................................................................................ 92 StdDev（標(biāo)準(zhǔn)偏差） ................................................................................................................................. 94 PopulationStdDev（總體標(biāo)準(zhǔn)偏差） ....................................................................................................... 95 Variance（方差） ...................................................................................................................................... 97 PopulationVariance（總體方差） ............................................................................................................ 98 Maximum（最大值） ................................................................................................................................ 99 Minimum（最小值） .............................................................................................................................. 101 Count（計數(shù)） ......................................................................................................................................... 102 DistinctCount（非重復(fù)計數(shù)） ................................................................................................................ 104 Correlation（相關(guān)系數(shù)） ........................................................................................................................ 105 Covariance（協(xié)方差） ..........