FunctionCopy link to clipboard
fixed( number, decimals, no_commas )
Rounds the specified number off to a certain number of decimals and returns it as text, with optional commas.
ParametersCopy link to clipboard
| Keyword | Type | Description |
|---|---|---|
|
|
Decimal |
The number that the fixed function will prepare for display. |
|
|
Number |
The number of digits after the decimal that will be maintained. 2 by default. |
|
|
Boolean |
Enter false to display commas, true to hide them. False by default. |
ReturnsCopy link to clipboard
Text
ExamplesCopy link to clipboard
fixed(7.36819) returns 7.37
fixed(7.36819, 3) returns 7.368
fixed(7.36819, 4) returns 7.3682
fixed(7000.36819, 4) returns 7,000.3682
fixed(7000.36819, 4, true) returns 7000.3682
fixed(7000.36819, 4, 0) returns 7,000.3682
Feature compatibilityCopy link to clipboard
The table below lists this function's compatibility with various features in Appian.
| Feature | Compatibility | Note |
|---|---|---|
| Portals | Compatible | |
| Offline Mobile | 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 | |
| Process Autoscaling | Compatible |