Analytics SAQL Developer Guide

Overview
Quick Start
Examples
SAQL Reference
SAQL Basic Elements
SAQL Operators
SAQL Statements
SAQL Functions
Aggregate Functions
Date Functions
Time Zone Date Functions
Work with Custom Fiscal Year Data
String Functions
Math Functions
abs(n)
acos(n)
asin(n)
atan(n)
ceil(n)
cos(n)
degrees(n)
exp(n)
floor(n)
log(m, n)
pi()
power(m, n)
radians(n)
round(n[, m])
sign(n)
sin(n)
sqrt(n)
tan(n)
trunc(n[, m])
Windowing Functions
coalesce
Query Performance
PDF

Math Functions

To perform numeric operations in a SAQL query, use math functions.

You can use SAQL math functions in foreach statements and in the filter by clause after a foreach statement.

You can't use math functions in a group by clause or in an order by clause. You also can't use math functions in the filter by clause before a foreach statement.