dollar() Function
This function may not be compatible with all features of Appian. For details, see the Feature Compatibility section below.

Function

dollar( number, decimals, no_commas )

Converts a decimal number into a dollar value by effectively adding a dollar sign ($), a decimal point, and optional comma for every three digits preceding the decimal.

Parameters

Keyword Type Description

number

Decimal

The number of dollars to be returned as text decimals.

decimals

Decimal

The number of digits after the decimal to display, 2 by default. Optional.

no_commas

Integer

An optional flag value indicating whether commas are used as number separators. It accepts 0 or 1. The default value is 0.

Returns

Text number

Usage considerations

Using the no_commas parameter

When the value for no_commas is 0, the dollar value displays a comma separator between every three and four digits that precede the decimal, when the number contains four or more digits before the decimal.

When the value for no_commas is 1, the dollar value is not separated by commas.

Formatting results

When displaying this value, you must use text formatting.

Examples

dollar(3213.43) returns $3,213.43

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Custom Record Field Expressions Incompatible
Open in Github Built: Wed, Aug 10, 2022 (11:20:24 PM)

On This Page

FEEDBACK