Math functions in Adobe Workfront Fusion
Access requirements
You must have the following access to use the functionality in this article:
To find out what plan, license type, or access you have, contact your Workfront administrator.
For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.
average ([array of values]) average(value1; [value2], …)
Returns the average value of the numeric values in a specific array, or the average value of numerical values entered individually.
ceil (number)
Returns the smallest integer greater than or equal to a specified number.
-
ceil(
1.2
)
Returns 2
-
ceil(
4
)
Returns 4
floor (number)
Returns the largest integer less than or equal to a specified number.
-
floor(
1.2
)
Returns 1
-
floor(
1.9
)
Returns 1
-
floor(
4
)
Returns 4
formatNumber (number; decimalPOINTS; [decimalSeparator]; [thousandsSeparator])
Returns a number in requested format. By default, the decimal point is a comma (,) and the thousands separator is a period (.).
formatNumber( 123456789 ; 3 ; , ; . )
max ([array of values]), max(value1;value2; …)
Returns the largest number in a specified array or the largest number among numbers entered individually.
min ([array of values]), min(value1; value2; …)
Returns the smallest number in a specified array or the smallest number among numbers entered individually.
parseNumber (number; decimal separator)
Parses a string with a number and returns the number. For example, parseNumber(1 756,456;,)
round (number)
Rounds a numeric value to the nearest integer.
-
round(
1.2
)
Returns 1
-
round(
1.5
)
Returns 2
-
round(
1.7
)
Returns 2
-
round(
2
)
Returns 2
sum ([array of values]), sum(value1; value2; …)
Returns the sum of the values in a specified array or the sum of numbers entered individually.