Including 0 values when calculating STDEV

Hello Everyone,    I am attempting to calculate the 26 Week STDEV for weekly sales.  The Sales records are daily so I am using a Date table to aggregate them by week.   The problem I am coming in...