Fixed Decimal issue

Question

I am trying to set certain columns of my data to the fixed decimal type with the format 19.2. There should never be more than 19 integers to the left and I only need it to two decimal points.

For some reason, I am getting errors that the values are not valid for fixed decimal even though the are numbers. They were also formatted as numbers in the original input file. See the screenshot below for some of the examples.

Any idea what is happening and how to fix?

markcurry · Answer

Don't forgot to convert the value in brackets to negative, and looking at your error message you seem to have multiple values to convert, so you can do this easily with the Multi-Field formula.....

Convert Numeric Values 2.yxmd

markcurry · Answer

Hi @lbaker

This issue is because string value for the number contains non-numeric characters like the () and the commas.

See the attached workflow on how to fix it.

Hope that helps

Convert Numeric Values.yxmd

binu_acs · Answer

@lbaker One way of doing this

toNumber_030223.yxmd