Text input - change data type

[ewall]

I have three data sets that I have in my workflow that I've copied/pasted into a Text Input for each. They have the same columns, so I've then unioned them together. I'm trying to use the Summarize tool, but the column that contains dollar values is configured as a String by default. When I try using Select or even Formula (toNumber) to convert the type to a double or Int, it then gives me either a null or 0 instead of the number itself.

I need to summarize the sum of these unioned data sets, so leaving it as a String won't work. Any ideas on how to fix?

[atcodedog05]

Hi @ewall 

Possibility could be dolor value might have string component like dollar sign, commas etc

See in my scenario I am able to take sum.

Hope this helps🙂

[ewall]

@atcodedog05 ah yes it does. Best way to remove that? Trim?

[atcodedog05]

Hi @ewall 

You can use replace function to remove them. And then convert to numbers.

[atcodedog05 · Accepted solution]

Like below

Input:

Formula :

Hope this helps 🙂