0 Replies Latest reply: Jan 5, 2016 11:00 AM by Tyler Gregory RSS

    Comparing a field across dates - Identify any changes

      Hello,


      I am trying to perform 3 steps, which are as follows:

       

      1.) Use an expression to list all items in a field that existed for date 1 and also for date 2.  (If a record was present for one date but not the other, I want it excluded).  Here is how I attempted this as a reference.

       

      =avg({$<Date1={'41275'},[Primary SecID] = p({$<Date1={'42360'}>}[Primary SecID])>}[iRisk Average Life])

       

      2.) Use an expression to list all items in a field that existed for date 2 and also for date 1.  (If a record was present for one date but not the other, I want it excluded).  Here is how I attempted this as a reference.


      At this point, I would have one column with all my date 1 values and another with all date 2 values based on the primary key, which is [Primary SecID].


      3.) I want to compare the results from step 1 and 2 below to identify any changes that occurred between the dates.


      *The field I am comparing is [iRisk Average Life] and the dates are '41275' and '42360'.


      Please let me know if this makes sense and if you are able to help.  Thank you!