2 Replies Latest reply on Aug 1, 2018 11:41 AM by Deepak Rai

    Multi-Criteria LOD, Maybe?

    Christi Kurihara

      I have a problem I think can be solved by an LOD expression, but I struggle with understanding LODs effectively and so am a little stumped.  I cannot share my data for confidentiality reasons but can work something up if required.  Basically, I have a list of sales users making calls with various companies.  I want to be able to pull back what the most recent call was, not in the future, for each sales user/account combination in order to see which ones are greater than 30 days since the last call.  In my head it sounds simple, but I have not yet been able to get it to work using just a {Fixed [Account], [Sales User]: max(start date)}, where "start date" excludes future dates.