User Guides

Name Arguments Return Description
Format_Number NUMBER value, [NUMBER decimal_points], [TEXT decimal_point_character], [TEXT thousands_seperator] TEXT Format a number with grouped thousands.
Category: Formatting Functions
Name: Format_Number
Arguments: NUMBER value, [NUMBER decimal_points], [TEXT
decimal_point_character], [TEXT thousands_seperator]
Return Type: TEXT
Description: Format a number with grouped thousands.
Examples: format_number(12000, 2) returns 12,000.00
format_number(13500.75,
2, “.”, “-“) returns 13-500.00
Format_Seconds NUMBER seconds TEXT Formats seconds to readable format.
Category: Formatting Functions
Name: Format_Seconds
Arguments: NUMBER seconds
Return Type: TEXT
Description: Formats seconds to readable format.
Examples: Format_Seconds(300) will return 5 minutes
Format_Seconds(176600)
will return 2 days 1 hours 3 minutes 20 seconds