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.