3 Replies Latest reply: Feb 24, 2015 5:11 AM by Manish Kachhia RSS

    How to calculate the Maximum price on basis of current selection of a date to previous 52 weeks

      Hi,

       

      I have a requirement as follows:

       

      When I select a date, i want to calculate the maximum price from that selected date to previous 52 weeks .

       

      Date               Price

      12/12/2013     500

      12/12/2014      200

      11/11/2014      400

       

      when I select the date as 11/11/2014 I should consider from 11/11/2014 to 52 weeks prior to that and fetch the maximum value.in this case I should get result as 500.

       

      similarly when I select a diff date,it should change dynamically.

       

      How do I accomplish this in qv?