promotion image of download ymail app
Promoted
liu 發問時間: 社會與文化語言 · 4 年前

[英翻中] which will sum only populated rows and divide that sum by the number of non-NULL rows. (完整句子在詳細資料中)?

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 個解答

評分
  • 琴研
    Lv 4
    4 年前
    最佳解答

    當前在單元格中的零值(NULL)將會導致平均數計算並不精准,因為表格只會把非零值的數值相加後,再把這個總數除以非零值(non-NULL)的行數。

    • Commenter avatar登入以對解答發表意見
  • 4 年前

    NULL, 一般是指空值 (NULL value), 它不是數字 0, 也不是, 空白, 比較像是遺漏值的意思

    • Commenter avatar登入以對解答發表意見
還有問題?馬上發問,尋求解答。