Multi row formula - adding commas and decimals

[Dittau]

Hello,

i’m trying to add commas and decimals to numbers in my alteryx flow. The numbers are all type: double.

example numbers:

45288412          

4023612.777191

3846427.472281

when i convert this in the multirow formula it converts to the below (ToString([_CurrentField_],0,1)

45,288,4

4,023,61

3,846,42

as you can see the commas are cutting things off incorrectly and there are no decimals being shown

what i would expect is the below

45,288,412          

4,023,612.78

3,846,427.47

[aatalai · Accepted solution]

@Dittau does this help

[Brando]

@aatalai good idea!

I spun my wheels trying to get this to work in the multi-row formula tool when using the standard formula tool was always the easy button. I hope it's still an appropriate solution for @Dittau.

Cheers!