Sum across multiple Columns on a single row

[Levin]

I cannot figure out why my formula is producing a [NULL] instead of the desired output. Below is example of workflow:

Formula for 'Device Count' field:

[0DR]+[2DR]+[6DR]+[SIM]+[DIM]+[PAS]+[7DR]+[STO]+[DTO]+[HTO]+[RRM]+[SRM]

(All of these fields are double)

Here is an example of the data:

Ship To	Ship To Name	0DR	2DR	6DR	SIM	DIM	PAS	7DR	STO	DTO	HTO	RRM	SRM	Device Count
XXX	XXX		2	15			9	6	7				11
XXX	XXX		2	14			5	8	1	5	1
XXX	XXX			1
XXX	XXX		6	17			13	11	13	2			21

[JordanB · Accepted solution]

Hi @Levin

The reason you are getting Null in the results is because your numeric fields have a 'null' in them. This means there is no numeric data in that cell. To get the correct summation I would suggest replacing these 'null' values with a 0. You can do this by inserting a Data Cleansing or Imputation tool before your formula tool.

Best,

Jordan Barker

Solutions Consultant

[Levin]

Thank You Jordan, I knew it had to be something simple!