MFR Sales Summary for #_planYear#

#lsDateFormat( _planStartDate )# through #lsDateFormat( _planEndDate )# as of #lsdateformat( _asOfDate )#

select * from qmd_lastYearSalesRaw where bgtcategoryId = select * from qmd_lastYearSalesDetail where sku = select * from qmd_lastYearSalesDetail where sku not in ( ) select * from qmd_lastYearSalesRaw where bgtCategoryId is null select * from qmd_lastYearSalesDetail where sku = select * from qmd_lastYearSalesDetail where sku not in ( )

Budget Category	TY #qmd_unitOfMeasure.unitOfMeasurePlural#	TY Pct. Tot.	LY #qmd_unitOfMeasure.unitOfMeasurePlural#	LY Pct. Chg.	TY Dollars	TY Pct. Tot.	LY Dollars	LY Pct. Chg.
#htmleditformat( bgtCategory )#	#listfirst( lsnumberformat( val( forecast_qty )), "." )#	#lsnumberformat( round( val( forecast_qty )/qtyTotal*100 ), "(9)")#%na	#listfirst( lsnumberformat( val( qmd_lastYearSales.forecast_qty )), "." )#	#lsnumberformat( round( lyChange/val( qmd_lastYearSales.forecast_qty )*100 ), "(9)")#% na	#rereplace( lscurrencyFormat( val( forecast_amt )), "\.\d*", "" )#	#lsnumberformat( round( val( forecast_amt )/amtTotal*100 ), "(9)")#%na	#rereplace( lscurrencyformat( val( qmd_lastYearSales.forecast_amt )), "\.\d*", "")#	#lsnumberformat( round( lyChange/val( qmd_lastYearSales.forecast_amt )*100 ), "(9)")#% na
#sku# #skuDesc#	#listfirst( lsnumberformat( val( forecast_qty )), "." )#	#lsnumberformat( round( val( forecast_qty )/_tyTotalQty * 100 ), "(9)")#%	#val( qmd_lySkuDetail.forecast_qty)#	#lsnumberformat( round( lyChange/val( qmd_lySkuDetail.forecast_qty )*100 ), "(9)")#% na	#rereplace( lscurrencyformat( val( forecast_amt )), "\.\d*", "" )#	#lsnumberformat( round( val( forecast_amt )/_tyTotalAmt * 100 ), "(9)")#%na	#rereplace( lscurrencyformat( val( qmd_lySkuDetail.forecast_amt )), "\.\d*", "" )#	#lsnumberformat( round( lyChange/val( qmd_lySkuDetail.forecast_amt )*100 ), "(9)")#% na
#sku# #skuDesc#	0	0%	#val( forecast_qty)#	#lsnumberformat( round( lyChange/val( forecast_qty )*100 ), "(9)")#% na	#rereplace( lscurrencyformat( 0 ), "\.\d*", "" )#	0%	#rereplace( lscurrencyformat( val( forecast_amt )), "\.\d*", "" )#	#lsnumberformat( round( lyChange/val( forecast_amt )*100 ), "(9)")#% na
All Other	#listfirst( lsnumberformat( val( forecast_qty )), "." )#	#lsnumberformat( round( val( forecast_qty )/qtyTotal*100 ), "(9)")#%na	#listfirst( lsnumberformat( val( qmd_lastYearSales.forecast_qty )), "." )#	#lsnumberformat( round( lyChange/val( qmd_lastYearSales.forecast_qty )*100 ), "(9)")#% na	#rereplace( lscurrencyFormat( val( forecast_amt ) ), "\.\d*", "" )#	#lsnumberformat( round( val( forecast_amt )/amtTotal*100 ), "(9)")#%na	#rereplace( lscurrencyformat( val( qmd_lastYearSales.forecast_amt )), "\.\d*", "" )#	#lsnumberformat( round( lyChange/val( qmd_lastYearSales.forecast_amt )*100 ), "(9)")#% na
#sku# #skuDesc#	#listfirst( lsnumberformat( val( forecast_qty )), "." )#	#lsnumberformat( round( val( forecast_qty )/_tyTotalQty * 100 ), "(9)")#%	#val( qmd_lySkuDetail.forecast_qty)#	#lsnumberformat( round( lyChange/val( qmd_lySkuDetail.forecast_qty )*100 ), "(9)")#% na	#rereplace( lscurrencyformat( val( forecast_amt )), "\.\d*", "")#	#lsnumberformat( round( val( forecast_amt )/_tyTotalAmt * 100 ), "(9)")#%na	#rereplace( lscurrencyformat( val( qmd_lySkuDetail.forecast_amt )), "\.\d*", "")#	#lsnumberformat( round( lyChange/val( qmd_lySkuDetail.forecast_amt )*100 ), "(9)")#% na
#sku# #skuDesc#	0	0%	#val( forecast_qty)#	#lsnumberformat( round( lyChange/val( forecast_qty )*100 ), "(9)")#% na	#rereplace( lscurrencyformat( 0 ), "\.\d*", "" )#	0%	#rereplace( lscurrencyformat( val( forecast_amt )), "\.\d*", "" )#	#lsnumberformat( round( lyChange/val( forecast_amt )*100 ), "(9)")#% na
Totals	#listfirst( lsnumberformat( qtyTotal ), "." )#		#listfirst( lsnumberformat( lyQtyTotal ), "." )#	#lsnumberformat( round( lyChange/val( lyQtyTotal )*100 ), "(9)")#% na	#rereplace( lscurrencyFormat( amtTotal ), "\.\d*", "")#		#rereplace( lscurrencyFormat( lyAmtTotal ), "\.\d*", "" )#	#lsnumberformat( round( lyChange/val( lyAmtTotal )*100 ), "(9)")#% na