Hey there! So, I am trying to alter a text into a floating decimal but I keep getting the "failed to parse" warning. For context, I'm uploading a CSV file that already has the field I'm needing as a currency. But, when I upload into Domo it turns it into a text. I will be needing to aggregate (sum) this field so I need it into a number instead of text.
I've tried replacing the '$' as an empty string and then altering the text to floating decimal, but that didn't work. I've also tried using the text formatting tile, but that doesn't appear to be giving me what I need either since removing the decimal only results in incorrect numbers.
Does anyone know a workaround for this without having to change the CSV file every time it's uploaded?
*I provided a screenshot of how the field looks like the CSV file prior to uploading into Domo.