community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Converting a string type to fixed decimal

Atom

Hiiiii everyone,

 

I just found the cell value of my "Salesvolume" field are gone after converting it from string to fixed decimal, does anyone confronting the same issue and do you know why that happened?

 

Thanks!!

 

salesvolume_-_string.pngSalesvolume - string (before)salesvolume_-_fixed_decimal_(10.2).pngSalesvolume - fixed decimal (10.2 after)

Alteryx Certified Partner
Alteryx Certified Partner

@EllaLiu,

 

Yes.  I do!

 

I would imagine that the fixed decimal that you chose was too small and that you received "Conv" error messages that the amount was too long to fit in this FixedDecimal.  Making the Fixed Decimal 19.2 should fix it.

 

If that isn't the case, try TrimLeft([SalesVolume],"0") before the conversion to Fixed Decimal.

 

Also, why not an integer?

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Atom

Thanks @MarqueeCrew!

 

I think that might be the reason, and you are right about the integer, I fixed this by change the data type to integer and then padding "0"s after converting to string again. That works too. 

 

Thanks again! 

 

Best,

 

Ella

Labels