Format numbers, currency and percentage values in text mode reports

Last update: January 16, 2025

CREATED FOR:

  • User

Numeric values including currency can be configured to display in a variety of formats in reports and lists in Adobe Workfront.

To modify the format of a numeric value, you must edit the valueformat line of your column.

For example, if you wanted to display the Budget column as $1000, the value format line would look like:

valueformat=currencyStringCurrencyRounded
valuefield=budget

For more information about applying conditional formatting in Workfront reports and lists using text mode, see Use conditional formatting in Text Mode.

You can format numbers using the following values for the valueformat line of your column:

Examplevalueformat=
1234doubleAsString
or
int
1,234doubleAsInt
$1,234currencyStringCurrencyRounded
1234.56doubleAsDouble
$1,234.56currencyStringCurrency
12%doubleAsPercentRounded
12.34%doubleAsPercent
(1,234.56)doubleAsFinancial
(1,234)doubleAsFinancialRounded
Previous pageFormat dates in text mode reports
Next pageCompare fields in conditional formatting

Workfront