Adding Values Resulting in Nulls

I’m running into an issue when I add up a couple of my totals columns. As you see below I’m trying to get a total for 2017-2019 but when I sum it up I am just getting null, is this a bug I’m running into?

Hey Zachary!

This is actually not a bug! In Sigma if you add anything to a null value you will get a null value in return. So if you wanted to get the total for 2017-2019 you would just need to add up 2017 and 2018.

Hi ztrean,

You can try the following formula.
Coalesce([2017], 0) + Coalesce([2018], 0) + Coalesce([2019], 0)

1 Like