Growth Assumptions on a consolidated level
What is the best way to make a growth assuption at a consolidated level and have the same % growth apply to GLs underneath? For example - I need to grow my Salary & wages by 3% and have that 3% apply to all the 10 different S&W GLs underneath it instead of breaking back like 0.3% per GL to get the total of 3% on Salary & Wages consolidation? I am not interested in inserting 30% at the consolidated level to get 3% per GL . Hope that makes sense.
You can use Lookup to get your % applied to Salary & Wages GL's. In order to use lookup you should have mapping between GL and GL group.
As Sai also mentioned, you can follow the below steps:
- In Parent module, store the percentages as input
- In second module with Child list as dimension, use the formula as attached below
Hope, this resolves your issue1