How to add columns with empty data

sirihofstadtrap — Mon, 08 May 2017 07:28:10 GMT

I have a table similar to this:

The columns have rows containing both numeric and empty data.

I want to create a new column (xyz) where I add the data in column x, y and z.

In other words, I want the result to look like the green xyz-column.

The problem is, when I run my script, I get the result in the red xyz-column..

How do I add columns with empty data?

I use the following script to create the xyz-column:

dt << New Column("xyz",

Numeric,

Formula(:Name("x")+:Name("y")+:Name("z")

)

);

Re: How to add columns with empty data

txnelson — Mon, 08 May 2017 12:19:43 GMT

Use:

dt << New Column( "xyz", Numeric, Formula( Sum( :x, :y,:z ) ) );

The Sum() function ignores missing values.

sirihofstadtrap — Mon, 08 May 2017 13:07:47 GMT

Thank you, it works :)