I added a column with this code:
= Table.AddColumn(#"Changed Type", "Total Quantity", each List.Sum(
{[species_males]+[#"species_females-mixed"]
}))
List.Sum is supposed to ignore null values and return the sum of the remaining values, however, my column contains a null value in every row where one of the input columns had a null value:
How can I fix this and create a calculated column that ignores nulls?