# Math Functions

NAME	SYNTAX	DESCRIPTION
SUM	SUM(value1,… valueN?) - > number	Adds all the numbers in the arguments, which can be numbers or node references
SUBTRACT	SUBTRACT(value1,… valueN?) - > number	Subtracts all the values in the arguments, which can be numbers or node references
PRODUCT	PRODUCT(value1,… valueN?) - > number	Multiplies all the values in the arguments
DIVISION	DIVISION(value1,… valueN?) - > number	Divides all the values in the arguments
AVERAGE	AVERAGE(value1,...valueN?) - > number	Returns the average (arithmetic mean) of its arguments, which can be numbers or node references
AVERAGEEXZERO	AVERAGEEXZERO(value1,...valueN?) - > number	Returns the average (arithmetic mean) of its arguments excluding zeros, which can be numbers or node references
AVERAGEEXNEG	AVERAGEEXNEG(value1,...valueN?) - > number	Returns the average (arithmetic mean) of its arguments excluding negatives, which can be numbers or node references
AVERAGEEXZERONEG	AVERAGEEXZERONEG (value1,...valueN?) - > number	Returns the average (arithmetic mean) of its arguments excluding zeros and negatives, which can be numbers or node references
COUNT	COUNT(value1,...valueN?) - > number	Counts the number of items in a range
ABS	ABS(value) - > number	Returns the absolute value of a number, a number without its sign
MIN	MIN(value1,...valueN?) - > number	Returns the smallest number in a set of values. Node references are also accepted as arguments
MAX	MAX(value1,...valueN?) - > number	Returns the largest number in a set of values. Node references are also accepted as arguments
POWER	POW(value,power) - > number	Returns the result of a number raised to a power
SQRT	SQRT(value) - > number	Returns the square root of a number
EXP	EXP(value) - > number	Returns e raised to the power of a given number
LOG	LOG(value,base) - > number	Returns the logarithm of a number to the base you specify
ROUND	ROUND(value) - > number	Returns the rounded value of the specified node, number
FLOOR	FLOOR(value) - > number	Returns the rounded down value of the specified node, number
CEILING	CEIL(value) - > number	Returns the rounded up value of the specified node, number

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.valq.com/model/formula-functions/math-functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.