adding numbers that are no longer numbers...

[Fiona_Gibson]

Hello

wondering if someone else might have come across this issue before,

i have number columns, which have had to be adjusted to remove the comma, that has been done but now i need to add two columns together, when i do this however as a formula to add columns what happens is these are merged not added,

for example 3230 + 186.5 =3416.5 but this shows as 3230187. 42+2.10 should be 44.1 but has become 422.1 and so one

i have tried adding the columns before the formatting change but i still see the same result it just merges the numbers

any thoughts or ideas will be appreciated as I'm feeling a bit stuck...added the output and the  workflow to show the problem.

thank you for your help.

Fiona

[SPetrie]

The original files didnt come along with the workflow so I cant really test it.

Looking at the setup though, your issue is the data types.

Even though you are converting the field values to numbers in the formula, you are still storing them inside a string data type.

I would suggest using a multi-field formula tool to do the transformations and you can change the field data type at the same time.

You can also, as another option, add a select tool and change the field types after your existing formulas, but the last formula with the addition would need to be moved to a new formula tool after the select has changes the data types.

[Qiu · Accepted solution]

@Fiona_Gibson 
Agree with @SPetrie , it seems that you are trying to change the data type with "ToNumber" function but still with the same column.
So eventually the Data Type is not changed.
We should use a new Column or Use a Select Tool after the formula tool/

[Fiona_Gibson]

 @SPetrie @Qiu  thank you both for  looking at this and for providing this guidance this is a real help and has helped me solve this!

thanks for making the time, best wishes

Fiona

[Qiu]

@Fiona_Gibson 
Glad to know it helped.

Thank you for your feedback.