Arithmetic Operators

Reference Guide > TDV Support for SQL Operators > Arithmetic Operators

Arithmetic Operators

The following arithmetic operators are built-in. You can select them from a cell drop-down list on a Grid panel:

• Add

• Concatenation

• Exponentiate

The table below summarizes the operator names and their symbols.

Operator Name	Symbol	String or Symbol Name
Add	+	Plus sign
Concatenate	\|\|	Double-pipe; two l bars
Divide	/	Forward slash
Exponentiate	**	Double-asterisk
Factorial	!	Exclamation mark
Factorial		“FACTORIAL”
Modulo	%	Percent sign
Multiply	*	Asterisk
Negate	-	Hyphen (minus sign)
Subtract	-	Hyphen (minus sign)