[英翻中] which will sum only populated rows and divide that sum by the number of non-NULL rows. (完整句子在詳細資料中)?
2016-09-08 7:09 pm
The presence of NULLs in a column may lead to inaccurate computations for AVG, which will sum only populated rows and divide that sum by the number of non-NULL rows.
回答 (2)
2016-09-09 12:54 am
✔ 最佳答案
當前在單元格中的零值（NULL）將會導致平均數計算並不精准，因為表格只會把非零值的數值相加後，再把這個總數除以非零值（non-NULL）的行數。
2016-09-09 1:20 am
NULL, 一般是指空值 (NULL value), 它不是數字 0, 也不是, 空白, 比較像是遺漏值的意思
收錄日期: 2021-04-30 21:48:54
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160908110921AA8Hc9Z