How to Convert to zero

[PassION_es]

Hello Alteryx community,

Please help how can I convert to zero from a long numbers.

[chuckleswk · Accepted solution]

If the field is a string field, you could always write a formula using the formula tool and then convert the column to a double using the select tool :

if contains([Amount],"E") then "0" else [Amount] endif

It would be helpful if you posted a sample of the input file.

[PassION_es · Accepted solution]

hi @chuckleswk , thanks for this. but i already figured out how to refrain from long numbers. This is by using the fixed decimal data type.