community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Sum across multiple Columns on a single row

Meteoroid

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 ToShip To Name0DR2DR6DRSIMDIMPAS7DRSTODTOHTORRMSRMDevice Count
XXXXXX 215  967   11 
XXXXXX 214  58151   
XXXXXX  1          
XXXXXX 617  1311132  21 
Alteryx
Alteryx

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.

 

pic1.jpg

 

Best,

 

Jordan Barker

Solutions Consultant

Highlighted
Meteoroid

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

Labels