5 Replies Latest reply on Oct 1, 2015 12:21 PM by Rody Zakovich

    LOD Challenge: Max of date less than date in current record

    Ira Skop

      I feel like this should be solvable with LOD expressions, but can't figure it out. The first 2 blue columns are in the data source. The last column is my LOD calculation. There is no guarantee that the progression of dates will be predictable (i.e. qtrly, monthly, etc.) so it can't be done with "math."

       

      I want to do something like:

      {Fixed [Claim number] : max(if [Valued as of] <= THIS RECORD's [Valued as of] then [Valued as of] else null end) }

       

      Seems like circular logic. Any ideas?

       

      Claim numberValued as ofPrevious Valuation
      A12/31/13null
      A3/31/1412/31/13
      A5/31/143/31/14
      A6/30/145/31/14
      A7/31/146/30/14