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?



      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.