15 Replies Latest reply: Aug 13, 2012 10:37 PM by Bill Ringer Salalima RSS

    How to do less than or equal to Date in Set Analysis?

      Hi,

       

      How to do this in set analysis,

       

      I want to display data where DATE is lessthan or equal to the maximum date

       

      Say, I selected or maximum date is 8/1/2012, so all data up to 8/1/2012 will be displayed. See my example below, it's not working!

       

      sum({$<[Days Over] = {'<=0'}, [Document Date] = {'<=max([Document Date])'}>} [Total AR])

       

      Please help. Thanks.