I have a number that I want to format as text, with commas and the dot

Use one of our passthrough functions. In case of Snowflake, it will look like this:

CallText(“TO_CHAR”, [SalesAmt], “999,999,999,999,999,999,999,999.00”)

Snowflake number formats are described here: SQL Format Models — Snowflake Documentation