To string conversion issue 345678.34343343 to $ 345,678.34

[subhajits11]

"$"+tostring([Base Pay],2,1)
not giving proper result.

[JosephSerpis · Accepted solution]

Hi @subhajits11 my only suggestion is to check the date type of your Base Pay field as it coming from a CSV it might be string field hence why the formula is not working. You can see the data type by using either a select or field info tool.