Math

ABS

BigQuery

Mengembalikan nilai absolut (positif) dari angka input.

Tipe hasil: Same as input typeDiperbarui: 7 Jan 2026

Syntax

SQL

ABS(expression)

expressionINT64/FLOAT64/NUMERIC/BIGNUMERICwajib

Nilai numerik

SQL

1 SELECT
2   value,
3   ABS(value) as absolute
4 FROM UNNEST([-10, 5, -3.5, 0]) as value;

Mengkonversi nilai negatif menjadi positif.

Hasil

SQL

1 SELECT
2   actual,
3   predicted,
4   ABS(actual - predicted) as absolute_error
5 FROM `project.dataset.predictions`;

Menghitung absolute error tanpa memperhatikan arah.

1	SELECT
2	actual,
3	predicted,
4	ABS(actual - predicted) as absolute_error
5	FROM `project.dataset.predictions`;