7 Replies Latest reply: Jan 6, 2014 5:30 AM by jagan mohan rao appala RSS

    Minumum of Average value in last 12 weeks

      Dear community,

       

      I would like to calculate the minimum value of average ROI in last 12 weeks.

       

      average ROI = sum([Revenue])/ sum([Media Investment])

       

      my expression as shown below will give me the result for whole year:

      =min(total <Region> aggr( sum([Revenue])/ sum([Media Investment]), Region))

       

      Where or how should I include this date expression in order to get the minimum of average ROI in last 12 weeks instead of whole year?

      Date={"<=$(=max(Date))>=$(=Date(max(Date)-77,'DD/MM/YYYY'))"},Year=,Quarter=,Month=,Week=>}

       

      Thanks and best regards,

      Chanel