adding numbers that are no longer numbers...

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

test output.csv

test example to add columns.yxmd

Developer

Tips and Tricks

Accepted answers

Qiu

@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/

All comments

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703