Adding a comma to output

[anitamarie2020]

Hi All,

I'm trying to set the below numbers so that they have commas and are rounded to the nearest decimal place.

Nothing seems to be working  

Can anyone suggest anything?

Thanks,

Anita

[apathetichell]

those are strings - not numbers. the formula tool will show you the type of data your field is.

You can convert with a multi-field formula or try:

tostring(round(Tonumber(first field)-[tonumber(second field),.1))

[apathetichell]

example. I'm using a multi-field formula to convert the two numeric fields into double. In my formula I then round to the nearest tenth - I could do .01 if I wanted nearest hundredth etc...

[anitamarie2020]

Thanks - 

Just when I ran the example below, I still can't get a comma in the output to seperate the numbers highlighted below 

[RaviP]

Hi @anitamarie2020

Let me know if the attached flow works for you.

[apathetichell]

Can you check under options/user settings - localization what does it say under thousand separator? Do you have it checked as none or comma?

On the workflow I posted - when I run it. I get commas.

69,430,905.38 for example...