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
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))
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...
Thanks -
Just when I ran the example below, I still can't get a comma in the output to seperate the numbers highlighted below
Hi @anitamarie2020
Let me know if the attached flow works for you.
