- Getting Started
- Administration Guide
-
User Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
- Data Governance and Modeling
- Working with Resources
- Working with Reports
- Working with Dashboards
- View and Manage Documents
- Understanding Wyn Analytical Expressions
- Section 508 Compliance
- Subscribe to RSS Feed for Wyn Builds Site
- Developer Guide
Math Functions
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:
ABS
Description
The ABS function returns the absolute value of a number.
Syntax
ABS(<number>)
Parameters
Parameter | Description |
---|---|
number | The number for which you want the absolute value. |
Return Value
A decimal.
Example
ABS('Sale'[Manufacturing Cost]- [Sale Price])
The above example returns the absolute value of the difference between the Manufacturing Cost and the Sale Price.
Remarks
The absolute value of a number is an integer or decimal number without negative(-) signs. If nested within a function that expects positive numbers, the ABS function can be used to ensure that only non-negative numbers are returned from expressions.
DIVIDE
Description
The DIVIDE function performs division and returns the alternate result on division by 0.
Syntax
DIVIDE(<numerator>, <denominator>)
Parameters
Parameter | Description |
---|---|
numerator | The dividend or number to divide. |
denominator | The divisor or number to divide by. |
Return Value
A decimal.
Example
DIVIDE(sum('Sale'[Amount]), Sum('Sale'[Price]))
Remarks
When the denominator is zero, the return value will be null.
MOD
Description
The MOD function returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.
Syntax
MOD(<number>, <divisor>)
Parameters
Parameter | Description |
---|---|
number | The number for which you want to find the remainder after the division is performed. |
divisor | The number by which you want to divide. |
Return Value
A whole number.
Example
MOD('Sale'[Price], 3)
Remarks
If the divisor is 0 (zero), MOD returns an error. You cannot divide by 0.
POWER
Description
The POWER function returns the result of a number raised to a power.
Syntax
POWER(<number>, <power>)
Parameters
Parameter | Description |
---|---|
number | The base number, which can be any real number. |
power | The exponent to which the base number is raised. |
Return Value
A decimal.
Example
POWER(11, 2)
The above example returns 121.
ROUND
Description
The ROUND function rounds a number to the specified number of digits.
Syntax
ROUND(<number>, <num_digits>)
Parameters
Parameter | Description |
---|---|
number | The number you want to round. |
num_digits | The number of digits to which you want to round. A negative value rounds digits to the left of the decimal point; a value of zero rounds to the nearest integer. |
Return Value
A decimal.
Example
ROUND(3.33333, 2)
The above example returns 3.33.
SQRT
Description
The SQRT function returns the square root of a number.
Syntax
SQRT(<number>)
Parameters
Parameter | Description |
---|---|
number | The number for which you want the square root, a column that contains numbers, or an expression that evaluates to a number. |
Return Value
A decimal.
Example
SQRT(2)
TRUNC
Description
The TRUNC function truncates a number to an integer by removing the decimal, or fractional, part of the number.
Syntax
TRUNC(<number>,<num_digits>)
Parameters
Parameter | Description |
---|---|
number | The number you want to truncate. |
num_digits | A number specifying the precision of the truncation; if omitted, 0 (zero). |
Return Value
A whole number.
Example
TRUNC(1.32,1)