Mathematical functions are very similar to Excel's mathematical functions, which are used to perform basic math functionality on your data. For example, you can use mathematical functions to find the square root, round, absolute value, and so on.
Following is the list of math functions supported in Wyn Enterprise:
Description
The ABS function returns the absolute value of a number.
Syntax
ABS(<number>)
Parameters
Return Value
A decimal.
Example
ABS('Sale'[Price])
The DIVIDE function performs division and returns the alternate result on division by 0.
DIVIDE(<numerator>, <denominator>)
DIVIDE(sum('Sale'[Amount]), Sum('Sale'[Price]))
The MOD function returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.
MOD(<number>, <divisor>)
A whole number.
MOD('Sale'[Price], 3)
The POWER function returns the result of a number raised to a power.
POWER(<number>, <power>)
POWER(11, 2)
The ROUND function rounds a number to the specified number of digits.
ROUND(<number>, <num_digits>)
ROUND(3.33333, 2)
The SQRT function returns the square root of a number.
SQRT(<number>)
SQRT(2)
The TRUNC function truncates a number to an integer by removing the decimal, or fractional, part of the number.
TRUNC(<number>,<num_digits>)
TRUNC(1.32,1)