Mathematical Operators and Functions

Operators

Mathematical operators are provided for many Drizzle types.

Operator Description Example Result
+ addition 2 + 3 5
- subtraction 2 - 3 -1
* multiplication 2 * 3 6
/ division 4 / 2 2
% modulo (remainder) 5 % 4 1
|/ square root |/ 25.0 5
||/ cube root ||/ 27.0 3
! factorial 5 ! 120
!! factorial !! 5 120
@ absolute value @ -5.0 5

Functions

The follow mathematical functions are provided by the Math Functions plugin.

Funciton Description
ABS Absolute value
ACOS Inverse cosine
ASIN Inverse sine
ATAN Inverse tangent
ATAN2 Inverse tangent
COS Cosine
LOG Natural logarithm
LOG2 Natural logarithm
LOG10 Base 10 logarithm
SIN Sine
POW Power
POWER Power
LN Natural logaritm
SQRT Squart root
CEIL Ceiling
CEILING Ceiling
EXP Exponential
FLOOR Floor
ORD Ordinal

Table Of Contents

Previous topic

Logical and Comparison Operators

Next topic

Date and Time Functions

This Page