4 Replies Latest reply: Mar 24, 2016 6:22 AM by Sunny Talwar RSS

    Help: AVG on aggregate

    Joycelyn Toh

      Hi Expert,

       

      May i know what should i write in order to get average of ACTUAL_MFG_TIME, when i change "Sum" to "Avg" and the figure go wrong. I have no idea what is going on.

       

      =Sum(Aggr(if(($(e_Actwip_Day)>=$(vToggle)),Sum({<REPORT_DATE = {">=$(=Date(Today()-30))<=$(=Date(Today()-1))"},CAL_GROUP={'D'}>}ACTUAL_MFG_TIME),0), Date_DDMMM,PC_IE_REPORT_GRP))

       

      Thanks for the help in advance.

      Joycelyn