4 Replies Latest reply: Jan 25, 2013 8:38 AM by Christian Conejero RSS

    How to get the Same Day Last Year with Set Analysis

    Jose Luis Garcia

      I want to compare daily sales with the equivalent day last year. The"Calendar" table  contains both fields: DateOrder and SameDayLY.

      I've tried countless expressions and the results are always wrong. The actual formula I use is

      Amount_SDLY = Sum ({$ <SameDayLY=,DateOrder = {'$(=Date(Max(SameDayLY), "dd/MM/yyyy"))'}>} Amount)

      sdly.PNG

      Curiously, Date(Max(SameDayLY), "dd/MM/yyyy"))' is correct for every date.

       

      I leave a sample document with dates in spanish format ('DD/MM/YYYY')

      Thanks for your help