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.