a!fixed() Function

Rounds the specified number off to a certain number of decimals and returns it as text, with optional commas.

Parameters

a!fixed( number, decimals, no_commas )

Keyword	Type	Description
number	Any Type	The number that the fixed function will prepare for display. Values can be of type Number (Decimal Precise) or Number (Decimal Floating).
decimals	Number (Integer)	The number of digits after the decimal that will be maintained. 2 by default.
no_commas	Boolean	Enter false to display commas, true to hide them. Default: false.

Returns

Text

Using the function

The following sections cover important details about the a!fixed() function.

Supported values in the number parameter

The a!fixed() function accepts Number (Integer), Number (Decimal Precise), and Number (Decimal Floating) values in the number parameter.

When you pass a Number (Decimal Precise) value, a!fixed() converts it to text without losing precision. If you specify the decimals parameter, a!fixed() rounds the value to that number of decimal places.

Examples

The following examples demonstrate the a!fixed() function.

To experiment with examples, copy and paste the expression into an expression rule and click TEST RULE to see the output.

Round a decimal to two places

a!fixed(7.36819) returns 7.37.

Round a decimal to a specific number of places

a!fixed(7.36819, 3) returns 7.368.

a!fixed(7.36819, 4) returns 7.3682.

Format a number with commas

a!fixed(7000.36819, 4) returns 7,000.3682.

Hide commas

a!fixed(7000.36819, 4, true) returns 7000.3682.

a!fixed(7000.36819, 4, 0) returns 7,000.3682. The value 0 is treated as false, so commas are displayed.

Feature compatibility

The table below lists this function's compatibility with various features in Appian.

Feature	Compatibility	Note
Portals	Incompatible
Offline Interfaces	Compatible
Sync-Time Custom Record Fields	Compatible	Can be used to create a custom record field that only evaluates at sync time.
Real-Time Custom Record Fields	Incompatible	Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.
Process Reports	Compatible
Process Events	Compatible	Can be used to configure a process event node, such as a start event or timer event.
Process Autoscaling	Compatible	Can be used in autoscaled processes.
Event Consumer Filter Conditions	Compatible	Can be used in filter conditions.
Event Consumer Event Handlers	Compatible	Can be used in event handler expressions.

Old versions

There are older versions of this function . You can identify older versions by looking at the name to see if there is a version suffix. If you are using an old version, be sure to refer to the corresponding documentation from the list below.

Old Versions	Reason for Update
fixed_26r9	Accepts values of type Number (Decimal Precise) in the number parameter.

To use the latest version of the function, replace the function with a version suffix with a new function reference.

To learn more about how Appian handles this kind of versioning, see the Function and Component Versions page.

Feedback