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?
