2 Replies Latest reply: Aug 8, 2017 12:35 PM by Jacob Salas RSS

    Working with Snapshot dates

    Jacob Salas

      Every day we snapshot our operations to store our hours.  Currently when we want to compare released work on the "snapshot" date it was released.

       

      I have a variable that calls out the released snap date: =date(aggr(min({<STATUS={'R'}>}SnapShotDate),%KEY_OPERATION))

      and a variable for the equation:  sum(aggr(sum({<SnapShotDate={'$(vDateR)'}>}EAC),%KEY_OPERATION))


      The formula works perfectly to the %key_operation only if that distinct %key_operation is selected.  if it is just the raw data the computation of that formula is 0.


      Can anyone help with this problem?  see attached example.


      Thank you.