Hi,
I am trying to remove the decimal point from a currency field on the saved search using TO_NUMBER(Replace({baseprice}, '.')), but the ".00" still shows up.
I also need to remove the commas that separate the thousands and add padding zeroes to the left to make the value 9 characters long.
The saved search column should show the price in the snapshot as 000198919