Value Formatting - Accounting /Finance Format

[HarishKhanna1]

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

[Bren_Spill2]

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

[cpet13 · Accepted solution]

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

[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

[HarishKhanna1]

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