Average of a calculated field that divides two columns
I have a calculated field that divides two columns for each row. We can call this calculated field 'row total' :
SUM(`Total A`) / NULLIF(SUM(`Total B`),0)
I am trying to get the overall average of all the Row Totals:
avg(NULLIF(`Total Views`, 0) / NULLIF(`Total Conversions`,0))
I have been checking the dataset and average in Excel, and it does not match the average I get from the above calculation.
Thanks for your help!