ÃÛ¶¹ÊÓƵ

Format numbers, currency and percentage values in text mode reports

Numeric values including currency can be configured to display in a variety of formats in reports and lists in ÃÛ¶¹ÊÓƵ 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:

Example
valueformat=
1234
doubleAsString

or

int
1,234
doubleAsInt
$1,234
currencyStringCurrencyRounded
1234.56
doubleAsDouble
$1,234.56
currencyStringCurrency
12%
doubleAsPercentRounded
12.34%
doubleAsPercent
(1,234.56)
doubleAsFinancial
(1,234)
doubleAsFinancialRounded
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43