Sets default formatting for numbers in Omni using a named format.
Sets default formatting for numbers in Omni, using a named format. Each format is two decimal places by default, except id, which does not include decimals.To set decimal length explicitly on a format, simply add {number_of_digits}, up to 4 digits (examples: format: number_4, format: big_1, format: usdaccounting_0). When decimal length is not set, decimals will be truncated to the shortest possible length for each row.Formats can also be set on a per-query basis using visualization configuration, using the same format types.
Formats are applied after the SQL, thus will not impact grouping. To handle grouping with truncation use ROUND() or FLOOR().
