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?



      Thanks and best regards,