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.
