How do I correct a data flow that has a "String" error?

kim_barragan0126

I am getting the below error on a data flow that has been working well for months. How can I fix this?

ColemenWilson

Use a formula tile with the following formula:

REPLACE(REPLACE(Column,'(','-'),')','')*1

ColemenWilson

Use a formula tile with the following formula:

REPLACE(REPLACE(Column,'(','-'),')','')*1

kim_barragan0126

Perfect! Thank you!