HOW TO CHANGE FORMAT?

JustynaMZ

Hi,

I have a table (example below)

I want to create column (called RESULT) which is a sum of columns a,b,c,d,e,

For this purpose I used Formula tool and put there instruction:

[a]+[b]+[c[+[d]+[e]

I received an error 'Type mismatch in operator +'

My assumption is that it is because of data format in a,b,c,d,e (VString and Double).

Can you please help me how to solve this problem?

I do not want to use ToNumber as in my real table I have around 30 columns that I need to add to receive the 'RESULT'

Thanks in advance for your help!

a	aa	b	bb	c	cc	d	e	RESULT
10	nn	1	ww	5	we	11	2	?
12	oo	2	ww	6	wqw	11	3	?
11	oo	3	ww	7	wew	11	33	?
14	ooo	4	we	8	wert	11	22	?

Common Use Cases

Accepted answers

Qiu

@JustynaMZ

We need something dynamic

0216-JustynaMZ.yxmd

All comments

AngelosPachis

Hi @JustynaMZ ,

Can't you use a select tool before that formula tool to change the data type to numbers for all columns included in that expression?

The select tool will allow you to change the data type from a dropdown list, so changing al V_String to Double should be enough

markcurry

Hi @JustynaMZ

There's a workflow with some options, I take it that the Dynamic Select won't work, if your numeric fields aren't set as numeric data types, but the top option should work for you....

Change Format.yxmd

pedrodrfaria

Hi @JustynaMZ

If you do not want to use the ToNumber, your only option pretty much is to manually change the columns to the double format with the Select tool and change it back afterwards.

However, be careful because the moment you change it from string to double, whatever does not fit in the double format will become null, so you may lose important data and not realize it.

I believe the best method is to definitely use the ToNumber(), it would be a quite large function, but it would make sure you did not lose any data.

Pedro.

Qiu

@JustynaMZ

We need something dynamic

0216-JustynaMZ.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703