formula to convert number to currently is giving error

‘$’, format(‘%.2f’, field(‘LocationSalesVolumeActual’))

Hi @jpca999,

what you posted is not a valid Baserow formula. What are you trying to do and what field and setting is “LocationSalesVolumeActual”?

If you are trying to do formatting on a number field, there is a feature currently under development that will allow you to format the number directly in the number field.

1 Like

I have data in text in the LocationSalesVolume field, and I want to:

  1. Convert this text into a number in currency format.

  2. Remove the original LocationSalesVolume column to eliminate any dependency on it.

Ok so you could reference and process your text field using a new formula field (with the replace and tonumber) functions. I recommend producing just a number without any formatting etc. After that you can change the field type of the new column from formula to number which will get rid of the dependency.

Before uploading the Excel file, make sure to convert the column to numbers (or remove the dollar sign). Then upload it, and the formula should work. Otherwise, the formula won’t function.