Expression output not coming

[tripatirao]

Dear All,

=SUM(AGGR((IF(SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]) > SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight]),0,

(IF(FABS((SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])- SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]))) < FABS(SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])*0.1),0,

SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])-SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]))))),[PCS_Line.PCS No_],PCS_Line.EntityIdentifier,PCS_Line.Region,PCS_Line.DeliveryDate,PCS_FiscalYear,PCS_month))

The above expression is not working for me

the value for MonthStart(max(PCS_Line.DeliveryDate)) is 1st Dec 2016 and Monthend(max(PCS_Line.DeliveryDate)),2) is 28th Dec 2017

But my expression value is showing for only 1st Dec 2016. it is not showing for the range.

Please let me know what might be the reason.

Regards

Tripati

[sunny_talwar]

Have you selected a particular date? May be try this:

=SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}

AGGR((IF(SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]) > SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight]),0,

(IF(FABS((SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])- SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]))) < FABS(SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])*0.1),0,

SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])-SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]))))),[PCS_Line.PCS No_],PCS_Line.EntityIdentifier,PCS_Line.Region,PCS_Line.DeliveryDate,PCS_FiscalYear,PCS_month))