6 Replies Latest reply: May 27, 2016 3:57 PM by Sunny Talwar RSS

    Max Date

    Mohammed Ismail Mustapha

      Goodafternoon to all,

       

      I am trying work out what the totaal sales is on the highest datum, or otherwise max(date). Sum({$<Date={'31-5-2014'}>}sales) gives a return. I should probably add that i cannot change the script, its locked down(long story). I can only do something with the expression, so can someone please help me out by explaining how i can change the aforementioned expression to work out the max(date). Thanks in advance.

       

      Mo