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

Question

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 Answer

@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