Math functions in Adobe Workfront Fusion

Access requirements

You must have the following access to use the functionality in this article:

Adobe Workfront plan*
Pro or higher
Adobe Workfront license*
Plan, Work
Adobe Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime Adobe Workfront Plan, your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described 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.

INFO
Examples:
  • ceil( 1.2 )

    Returns 2

  • ceil( 4 )

    Returns 4

floor (number)

Returns the largest integer less than or equal to a specified number.

INFO
Examples:
  • 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 (.).

INFO
Example:
formatNumber( 123456789 ; 3 ; , ; . )
Returns 123.456.789,000

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.

INFO
Examples:
  • 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.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43