Sum across multiple Columns on a single row

HBromell

I am trying to sum across a few columns then subtract that value from the sum of another group of collumns.  For example- I want to sum the total of all fruit, sum all vegetables then get the difference. How would I do this in alteryx? 

Baskets       Apples      Oranges    Grapes     Zuchini   Spinach    

Combo 1     10.2             2.5             31            12           

Combo 2      null             10.5          null            45.5        12.2               

Combo 3      5                  7.5           12             null          31

Combo 4      7                 12.5            7              2.5          10 

dataMack

If it's just thoe few columns, I would do it directly like this:  Drag a Formula tool onto the canvas connected to your data.  Pick some numeric data type (ex. int32) and give it a meaningful name, for example 'FruitLessVeggies'.  Your fomrula would be:

([apples]+[oranges]+[grapes])-([zuchini]+[spinach])