5 Replies Latest reply: Nov 17, 2016 5:47 AM by Antonio Mancini RSS

    aggr function on date

    ARINDAM DUTTA

      Hi  I want to find recency for every customer for that I am using  the following expression,

      (Today()-max(((aggr(Date,ClientNumber))))) . But this is giving only one value .Can any one suggest a better way.All I need is to get the maximum transaction date of a particular customer and subtracting it from today's date