My idea is to assign a 0 when there is a null, when we group it, so this can be achieved just simply using Sum(Sales) as Sales When we use Sum(Sales) the null values are treated as 0 right. then why are we using alt(sum(sales),0)
Does this alt function affects performance of the load when dealing with 25 millions of records Test: Load, ID, Alt(sum(sales), 0) as Sales resident abc group by ID;
