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?
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.
You can try the following formula.
Coalesce(, 0) + Coalesce(, 0) + Coalesce(, 0)