Consensus forecast ASP is not getting derived for the months where We are deriving ASP from marketin
Summary:
Consensus forecast ASP is not getting derived for the months where We are deriving ASP from marketing ASP in outer Qtrs and from Sales ASP for first 2 qtrs.
Expression: -
Consensus Forecast ASP Expression- if(LITE Fcst Disagg Control=0,0,Nvl(LITE Weekly POR ASP, LITE Marketing Fcst ASP))
LITE Weekly POR ASP-Archive(LITE Marketing Fcst ASP,1,'Version','Rolling')
LITE Marketing Fcst ASP- If (LITE PLM Qtrs Lock = 1, LITE: Sales Fcst ASP, Nvl(LITE: PLM Fcst ASP, LITE: Sales Fcst ASP))if (LITE Fcst Disagg Control=0,0, Nvl(LITE: DM Fcst Qty, nvl(LITE Weekly POR Qty,LITE Marketing Fcst Qty)))
Tagged:
0