Formula that will allow me to divide a child by the parent

neg177
neg177
in Modeling

Hi,

Need help creating a formula that will divide a child in a list by the parent. 

screen shot of the formula I have 

neg177_0-1623104386874.png

neg177_0-1623104617217.png

Looking to take the Amt from both Direct & ISO and divide them by the All BU parent from another module in their specific columns. 

 

 

Tagged:

Best Answers

  • LipChean_Soh
    LipChean_Soh
    Answer ✓

    Hi @neg177 

     

    Assuming 'All BU' is the 'Top Level Item' of your list, then you can use SELECT to reference parent values as shown below:

    LipChean_Soh_0-1623112070872.png

     

    Thanks,

    LipChean

  • ChrisAHeathcote
    ChrisAHeathcote
    Answer ✓

    @neg177 

    Use a LOOKUP of the parent for items other than the first level within the hierarchy and SELECT for the top level for the first level parent. 

     

     

Answers

  • neg177
    neg177

    Thank you. Very helpful and we got the formula we needed. 

Categories