Value Formatting - Accounting /Finance Format

Hii
Can anyone suggest a logic to convert value for example 123678453 to format 123,678,453.00 using alteryx and output to excel in the same format.I have tried using TOSTRING formula .But this logic is not working for the values generated within Alteryx flow.
I am sharing workflow that has the values to be formatted in text input tool .Can anyone figure out this and share the solution as a workflow

Acctng Format.yxmd

Acct Format.PNG

Preparation

Accepted answers

cpet13

@HarishKhanna1 this will do what you need it to, I think.

Acctng Format.yxmd

All comments

Bren_Spill2

@HarishKhanna1 - change the value field to numeric type then use ToString([Value],2,1)

cpet13

@HarishKhanna1 this will do what you need it to, I think.

Acctng Format.yxmd

HarishKhanna1

@cpet13 Thanks so much

HarishKhanna1

@cpet13 @Bren_Spill2 In the output excel sheet , they are aligned towards left which indicates they are string type .Is there any way to convert these to numbers , preserve formatting and have the Sum , Average , Count displayed in excel

Bren_Spill2

@HarishKhanna1 - you'll need to use the reporting tools to do what you need. See attached

Number Formatting.yxzp

HarishKhanna1

Hi @Bren_Spill2 can you please try this with the sample worfklow that I attached above : "Acctng Format.yxmd"

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703