Summation of Fields as a Calculated Field Error

Question & Answer
,
1

I’m trying to create a calculated field that totals the sum of three cost columns. At present, it appears as though QuickSight is only summing those rows that have values within all three cost columns. Any way around this?

Current calculated field code is: avg({column_1})+avg({column_2})+avg({column_3})
using average as there are duplicate entries from the DB, so this makes it static

image

2

Found solution.

avg(ifelse(isNull({column_1}), 0, {column_1})) + avg(ifelse(isNull({column_2}), 0, {column_2})) + avg(ifelse(isNull({column_3}), 0, {column_3}))