You built your workbook with all metrics and calculations, but now the end user makes the final analysis and realize you forgot a metric! (Now you’re pissed!) According to the user, this new metric has to bring the parental participation of a measure to the total of the company or at the highest level of the hierarchy.
So now you need go back to the whiteboard to analyze what you need to change to meet this need! Perhaps you may not know, but exist a feature in RPAS can solve your problem without many impacts in your configuration.
After talked with some readers, I realized some difficulties about elapsed’s operation within a workbook, like “Why elapsed lock my measures?” and “Where can I change elaped definitions?”
Elapsed is not complicated, but exists some details where you need to know to don’t threaten in the workbook. Because of that, we decided to write on this topic to help others don’t known about. Continue reading →