Growth Assumptions on a consolidated level


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.




  • 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.

    V.Sai Bharadwaj

    Connect on LinkedIn

  • HimanshuRaj
    edited March 2023

    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