Growth Assumptions on a consolidated level

Megha27

Hi Experts,

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.

Thanks,

Megha

Sai_Bharadwaj_Venati

Hi Megha,

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.

HimanshuRaj

Hi @Megha27

As Sai also mentioned, you can follow the below steps:

1. In Parent module, store the percentages as input
   
2. In second module with Child list as dimension, use the formula as attached below
   
   

Hope, this resolves your issue