Replicate Excels 'Comma Style' formatting of numbers

Question

Good day, I am trying to replicate Excels number formatting 'Comma Style' in Alteryx when outputting reports, i.e. format with a thousands separator (a space not a comma). Also, zero should appear as a dash, i.e. - instead of 0.

Any suggestions would be appreciated?

Aguisande · Accepted Answer

Hi @Alastair

Using the optional parameters in the ToString function may help you.

Like:

ToString([number], 2, 1)

For thge Zero, a simple formula will do:

IF [number]=0

THEN "-"

ELSE [number]

ENDIF

Hope this helps

Best,

_AG_

Aguisande · Accepted Answer

@Alastair

Maybe using the ReplaceChar function ( ReplaceChar(String, character to replace, character to replace with)) may help you. In this case it'll be ReplaceChar(String, ","," ")

Aguisande · Accepted Answer

Please, check the length of the String being generated in the formula