7 Replies Latest reply: Jul 19, 2016 5:49 PM by Goutham Kandukuri RSS

    Set analysis Date selection issue

    Goutham Kandukuri

      HI,

      i have an expression as below

      =Avg({$<Date ={">=$(=max([customerdate]))"}>}val)

       

      when i am manually selecting the date from a list box (eg: 06/01/2016 to 06/30/2016), i am getting the correct average.

       

      But when i am selecting from a calendar object(Same date range), i am getting a different average.

      Calendar object variables are defined as below

      startdate: ='>='& vStartDate

      Enddate : ='>='& vStartDate & '<=' &vEndDate

       

       

      Can some one please advise.