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