Comments
-
I standardized the date and next I tried this formula to give variance but it's not giving me any value. Any idea what I might be doing wrong here? CASE when Account = 'Sales' then ((CASE WHEN MONTH(Date) = MAX(MONTH(Date)) THEN SUM(Sales) END) - (CASE WHEN MONTH(Date) = MAX(MONTH(Date))-1 THEN SUM(Sales) END)) / (CASE…
