CMS MTD
DateTime = DateTimeAdd(DateTimeToday(),
(DateTimeDay(DateTimeToday())-1)*-1,"day...
C:\Users\ewilcox\AppData\Local\Temp\Engine_11096_059100751dad4d259b209e3be9c364f3_\Engine_6064_7fd2a28c180c4fc9a6d50a37183b2656_.yxdb
Single
Profile
1
aka:WMM_APA|||Select r.STORE_NBR, i.DEPT_NBR As OD, Sum((r.SAT_QTY * c.SAT_MULT) + (r.SUN_QTY * c.SUN_MULT) + (r.MON_QTY * c.MON_MULT) + (r.TUE_QTY * c.TUE_MULT) + (r.WED_QTY * c.WED_MULT) + (r.THU_QTY * c.THU_MULT) + (r.FRI_QTY * c.FRI_MULT)) As Volume, Sum((c.SAT_MULT * r.SAT_SALES_AMT) + (c.SUN_MULT * r.SUN_SALES_AMT) + (c.MON_MULT * r.MON_SALES_AMT) + (c.TUE_MULT * r.TUE_SALES_AMT) + (c.WED_MULT * r.WED_SALES_AMT) + (c.THU_MULT * r.THU_SALES_AMT) + (c.FRI_MULT * r.FRI_SALES_AMT)) As Sales From gb_wm_vm.sku_dly_pos r, gb_wm_vm.item i, gb_wm_vm.calendar_day c Where r.ITEM_NBR = i.ITEM_NBR And c.WM_YR_WK = r.WM_YR_WK And i.DEPT_NBR In (38) And c.GREGORIAN_DATE Between Date '2019-01-01' And Date - 1 And i.OLD_NBR In (3805266) Group By 1, 2 Order By 1, 2
True
False
Quoted
False
ModifySQL
DateTime
2019-01-01
aka:WMM_APA|||Select r.STORE_NBR, i.DEPT_NBR As OD, Sum((r.SAT_QTY * c.SAT_MULT) + (r.SUN_QTY * c.SUN_MULT) + (r.MON_QTY * c.MON_MULT) + (r.TUE_QTY * c.TUE_MULT) + (r.WED_QTY * c.WED_MULT) + (r.THU_QTY * c.THU_MULT) + (r.FRI_QTY * c.FRI_MULT)) As Volume, Sum((c.SAT_MULT * r.SAT_SALES_AMT) + (c.SUN_MULT * r.SUN_SALES_AMT) + (c.MON_MULT * r.MON_SALES_AMT) + (c.TUE_MULT * r.TUE_SALES_AMT) + (c.WED_MULT * r.WED_SALES_AMT) + (c.THU_MULT * r.THU_SALES_AMT) + (c.FRI_MULT * r.FRI_SALES_AMT)) As Sales From gb_wm_vm.sku_dly_pos r, gb_wm_vm.item i, gb_wm_vm.calendar_day c Where r.ITEM_NBR = i.ITEM_NBR And c.WM_YR_WK = r.WM_YR_WK And i.DEPT_NBR In (38) And c.GREGORIAN_DATE Between Date '2018-01-01' And Date - 366 And i.OLD_NBR In (3805266) Group By 1, 2 Order By 1, 2
True
False
Quoted
False
ModifySQL
DateTime
2018-01-01
Warning
All
ByName
C:\Users\ewilcox\AppData\Local\Temp\Engine_11096_059100751dad4d259b209e3be9c364f3_\Engine_6064_6b6f02d778604bf3b174af412b6801f7_.yxdb
Single
Profile
Horizontal
Current Month