Error: Not a valid FixedDecimal, must be in the form: -nnn.nn

[Phyllis]

Hi, just started using Alteryx and for some reason I'm getting the error below and it seems to only happen with numbers with thousands (?) The rest of the numbers seem to be fine.

It looks like there's a space after the 2nd decimal, but not sure if that's the case. I have a "data cleanse" bubble before the error so I'm not sure why that might be happening.

This is what it looks like:

I tested other types and tried other sizes but it seemed to keep happening.

Thanks!

[MarqueeCrew · Accepted solution]

@Phyllis,

The expression below will fix the issue for you.  It will cleanup the field:

RegEx_Replace([Spend],"[^0-9.]",'')

Anything not in the set of {0,1,2,3,4,5,6,7,8,9,.} or {0 to 9 and a decimal} will be dropped.

Cheers,

Mark

[sporter]

Hi, I used the above solution to clean up some numbers from a data set I was importing. However, my data includes many negative numbers and this solution converted all negative numbers to positives. Is there a similar way I might be able to use this formula but still maintain my negative numbers?

Thanks!