Is there a beast mode I can use to add two columns and then get the average?

kim_barragan0126

david_cunningham

@kim_barragan0126

If it’s always just the 2 columns, and you will have nulls. You could do

(col1+col2)/2

Sean_Tully

Maybe something like:

sum(ifnull(`R-Phone Interview`, 0) + ifnull(`R-Virtual Interview`, 0))/(count(`R-Phone Interview`) + count(R-Virtual Interview))

ArborRose

As mentioned, it's just (col1+col2)/2. Use coalesce(col1,0) if you have nulls. They will become zero.

david_cunningham

@kim_barragan0126

If it’s always just the 2 columns, and you will have nulls. You could do

(col1+col2)/2

Sean_Tully

Maybe something like:

sum(ifnull(`R-Phone Interview`, 0) + ifnull(`R-Virtual Interview`, 0))/(count(`R-Phone Interview`) + count(R-Virtual Interview))

ArborRose

As mentioned, it's just (col1+col2)/2. Use coalesce(col1,0) if you have nulls. They will become zero.

kim_barragan0126

Thank you all!