This content has been marked as final.
Show 1 reply
-
1. Re: Aggregation Issue (Part II)
Shinichiro MurakamiFeb 16, 2016 5:39 PM (in response to Harnish Patel)
1 of 1 people found this helpfulNo, as long as your LOD calc include [Pay period], it contemplate it in calculation.
{fixed [Facility], [Cost Center], [Pay Period]: MAX([2014 App WLU])}
You can see each cost center has different pay period, then Max of [2014 App WLU] is different from Cost center.
If you need Max across period, you can remove [Pay Period] from the LOD.
But I still don't understand where your comment come from QA: The sum of A Cost Center 6000 should be the ball park of 8563.
Instead, if you filter [Pay period], you can get same number for same cost center.
Thanks,
Shin