fixed( number, decimals, no_commas )
Rounds the specified number off to a certain number of decimals and returns it as text, with optional commas.
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. |
Text
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 | 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 |
fixed() Function